APEX Instant Tips #52 – “Function Body returning SQL Query” For the win

19Nov

APEX Instant Tips #52 – “Function Body returning SQL Query” For the win

By: Marc Ruel On: November 19, 2021 In: APEX Developer Solutions, Instant Tips Comments: 0

In this episode, Anton and Hayden cover how applying report region source type of “function body retuning sql query” can improve performance.

Useful Link:
A conversation string on a question put to Tom Kyte about comparing the cost of 2 queries
“You cannot compare the cost of 2 queries with eachother. [sic]” -Tom Kyte
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:313416745628

Insum's APEX Instant Tips: Every Friday at 12:05pm EST

Join Anton and Hayden every Friday at 12:05pm EST live on our Facebook and YouTube channels, as they present a new APEX tip every week.

Subscribe and hit the bell to be notified so you never miss a thing!

View Past Episodes

Full episode list on YouTube here.

Past Episodes

Share this:

Leave reply:

Cancel reply