Reblogged from Oracle Scratchpad:
As in - how come a unique (or primary key) index is predicted to return more than one row using a unique scan. Here's and example (running on 10.2.0.3 - but the same type of thing happens on newer versions):
Reblogged from Oracle Scratchpad:
As in - how come a unique (or primary key) index is predicted to return more than one row using a unique scan. Here's and example (running on 10.2.0.3 - but the same type of thing happens on newer versions):