19Nov
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.

Share this:
Share

Leave reply:

Your email address will not be published.