In this episode, Anton and Hayden cover how applying report region source type of “function body retuning sql query” can improve performance.
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
View Past Episodes
Full episode list on YouTube here.
APEX Instant Tips #104: Alternative methods for hiding and showing columns
Hayden and Anton explore methods for hiding and showing columns including serverside condition, dynamic action "hide"...Read more
APEX Instant Tips #103: Three Interactive Report tips
in 5 minutes, Anton and Hayden take us through 3 useful tips 1. How to shorten...Read more
APEX Instant Tips #102: on “Prevent Lost Updates,” “Lock Row,” and “ListAgg.
Anton and Hayden take you as deep as they can go in 5 minutes on "Prevent...Read more
APEX Instant TIps #101: 3 gripes about APEX
In this episode, Anton and Hayden unpack 3 gripes they have about APEX and include some...Read more
APEX Instant Tips #100: Extra Sketchy Tip!
Hayden and Anton have held onto this "extra sketchy" tip for quite a while. It's worthy...Read more
APEX Instant Tips #99: Connecting an APEX app to GPT-3
Anton and special guest Michelle Skamene show you how to create a GPT-3 REST Data Source...Read more
APEX Instant Tips #98: An easier way to give secure access to a REST enabled schema
Anton describes how to give access to a REST-enabled schema by simply granting the SQL developer...Read more
APEX Instant Tips #97: What should :APP_USER contain?
For active APEX users, switching user names can be a major inconvenience. Anton recommends setting APP_User...Read more