Unique Indexes Force Hints To Be “Ignored” Part I (What’s Really Happening)

Richard Foote's picture

As I was compiling my new “Oracle Diagnostics and Performance Tuning” seminar, I realised there were quite a number of indexing performance issues I haven’t discussed here previously. The following is a classic example of what difference a Unique Index can have over a Non-Unique index, while also covering the classic myth that Oracle sometimes […]

To prevent automated spam submissions leave this field empty.