Re: Help Optimizing Large Query Sort (Detailed)
> I plan to purge records from this table to speed it up, which would accomplish the same thing as the index... reducing the number of rows to be scanned...
Not equivalent; scanning data is much slower than scanning an index.
Subject
Views
Written By
Posted
1860
March 04, 2013 03:08PM
910
March 05, 2013 11:08PM
1197
March 06, 2013 02:40PM
841
March 07, 2013 07:17PM
838
March 11, 2013 01:39PM
Re: Help Optimizing Large Query Sort (Detailed)
671
March 11, 2013 09:14PM
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.