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 #177: The second 5 minutes of almost every code review
For this episode, log into your APEX development workspace and follow along with this code review....
Read more
APEX Instant Tips #176: “Session State Protection” vs “Value Protected”
2 settings, Session State Protection and Value Protected, and 3 places they can apply. Anton and...
Read more
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