By: Marc Ruel On: April 2, 2024 In: Instant Tips Comments: 0

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/

Insum's APEX Instant Tips: Every Friday at 12:05pm EST

Join Anton and Marwa most Fridays at 12:05pm EDT live on our Facebook and YouTube channels, as they present a new APEX tip.

Subscribe and hit the bell to be notified so you never miss a thing!

View Past Episodes

Full episode list on YouTube here.

Share this:

Leave reply:

Your email address will not be published. Required fields are marked *