Re: does this "top-200" query do a table scan
Posted by:
Rick James
Date: October 31, 2015 05:51PM
I agree that the ORDER BY is mandatory.
Use EXPLAIN SELECT ... to see if it is a table scan. It will say "All" if it is.
But note... The optimizer may decide that a table scan is faster than bouncing between the index and the data.
Subject
Views
Written By
Posted
1529
October 27, 2015 05:50AM
746
October 31, 2015 12:22AM
736
October 31, 2015 10:15AM
658
October 31, 2015 01:03PM
Re: does this "top-200" query do a table scan
736
October 31, 2015 05:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.