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
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #147: Why are Ajax Callback processes so hard to use?
Ajax callbacks are hard to use: Learn the javascript and be careful about syntax. Marwa and...
Read moreAPEX #146: APEX Instant Tips #146: Extending Faceted Search
Hosts Anton and Marwa talk about how to make a page item look and behave like...
Read moreAPEX Instant Tips #145: How to know if the data in your Interactive Grid row changed
:APEX$ROW_STATUS is a pseudo column that can be used in PL/SQL, just like any other interactive...
Read moreAPEX Instant Tips #144: When to_date
To_date, To_number, and To_timestamp stem from how APEX stores and treats Session State. Anton and Marwa...
Read moreAPEX Instant Tips #143: Javascript and css from pl/sql
In this episode, Marwa and Special guest Eglé describe how to add javascript code and CSS...
Read moreAPEX Instant Tips #142: LOV additional columns
Michelle sits in for Anton this week as Marwa shows you how to leverage additional columns...
Read moreAPEX Instant Tips #141: The APEX qAsk application
The APEX qAsk application can be used for live surveys. Anton and Marwa demonstrate and point...
Read moreAPEX Instant Tip #140: A tip for when merging working copies
When merging a copy back into an APEX app, make sure to unclick anything that says...
Read more