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 #162: About Display Only Items in Oracle APEX
In this week's tip, any time you set a value in the browser, a user could...
Read more
APEX Instant Tips #161: More about hashing than you could possibly want to know…but you should.
Marwa and Anton take you through hashing and checksums. Maybe more than you could possibly want...
Read more
APEX Instant Tips #160: APEX utilities you may never need, but if you do, they’re good to know.
Anton and Marwa show you the utilities you can find in APEX Object Reports, and there...
Read more
APEX #159: Recipes from the IG Cookbook
Marwa and Anton show you amazing things you can do with an Interactive Grid through recipes...
Read more
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
