Oracle 11.2 Outer Join And Index Issue This is an off-site link.  Please review our Terms of Service for additional information.

(David Fitzjarrell) While investigating a question on returning unmatched rows between two tables I set up an example where both tables had indexes that could be used to speed up the query and hopefully return the result set in less time than required for a full table scan. To my surprise when the index was used on the table with the missing record the query returned no rows.

Read this article...

comments powered by Disqus