Anton explains why all your tables with foreign keys should have an index on the foreign key.
Useful link
Rich Soule’s blogpost on the subject. Try his query! https://carsandcode.com/2023/09/01/finding-unindexed-foreign-keys-in-oracle-now-with-index-creation-ddl/
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #158: Opening multiple browser tabs
Are you concerned about users opening multiple browser tabs? You should be...Marwa and Anton explain.
Read more
APEX #157: Refreshing Region Plugin Regions
Anton and Marwa discuss how to make region plugins regions refreshable. Anton provides a boilerplate plugin...
Read more
APEX Instant Tips #156: Informing users about background processes
Anton and Marwa discuss Background processes: informing users of what is happening and what occurs upon...
Read more
APEX Instant Tips #155: About icons and buttons builder
We have extended the Universal Theme application to allow more customization within the icon and button...
Read more
APEX Instant Tips #154: How to Recenter a Map Region
What is this episode about? Hint: Initial position in zoom, isn’t enough…
Read more
APEX Instant Tips #153: Everything you always wanted to know about combobox but never thought to ask
With Combo boxes, you must manage your business rules and watch for multi-user concurrency issues. Anton...
Read more
APEX Instant Tips #152: APEX.debug
In this episode, Anton and Marwa compare Console.log, APEX_debug.log, APEX_debug.message, and APEX.debug.setlevel.
Read more
APEX Instant Tips #151: Updates to tips 148, 146 & 53
A review and update of 3 previous instant tips: Checksum, Faceted Search, and Multilingual Apps from...
Read more
