MySQL Forums
Forum List  »  Partitioning

Re: Optimizations on ORDER BY with partitions
Posted by: James Porter
Date: April 12, 2006 11:28PM

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.

Options: ReplyQuote

Written By
Re: Optimizations on ORDER BY with partitions
April 12, 2006 11:28PM

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.