Originally posted on 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):

View original 568 more words

About these ads

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s