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 #175: Why is my APEX item null? What is item “Storage”?
Be aware of the order of operations in APEX. Keep this in mind: Processes happen before...
Read more
APEX Instant Tips #174: Dynamic Actions and Order of Execution
Dynamic actions have brought client-side JavaScript to everyone, but it is still important to understand a...
Read more
APEX Instant Tips #173: Naming User Preferences
Anton teams up with very special guest Hayden Hudson to add a follow up on epsisode...
Read more
APEX Instant Tips #172: Region Template Best Practices
Standard? Blank with Attributes? Blank with Attributes (No Grid)? When should I use each of these...
Read more
APEX Instant Tips #171: APEX v24.2 Opening Modal Dialog Pages
When upgrading to APEX v24.2 be sure to fix custom javascript that opens modal dialog pages...our...
Read more
APEX Instant Tips #170: Find matching members in two “multi-value”, colon separated strings
A quick method to determine if two "multi-value" strings (e.g. colon separated) have any matching members.
Read more
APEX Instant Tips #169: A return to writing fast queries…and a function to make it easier.
Think you can’t learn anything valuable in 5 minutes? Anton and Marwa will prove you wrong,...
Read more
