Re: Optimizations on ORDER BY with partitions
The major speed improvement that I see with partitioning is the fact that it avoids having to do a full table scan for a query. The less data that is read, the faster the query. We all know the limiting speed factor these days is the hard drive.
By catch-all I was referring to range partitioning. If you can create specific partitions for common ranges and then use your catch all for less common ranges. This pattern would make queries for your common ranges fast and also speed up queries that operate on one extreme of your ranges.
Subject
Views
Written By
Posted
3350
March 09, 2006 11:41PM
2430
March 21, 2006 04:22PM
Re: Optimizations on ORDER BY with partitions
2198
April 12, 2006 11:28PM
2298
April 13, 2006 12:09AM
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.