MySQL Forums
Forum List  »  Partitioning

Re: Pruning problem.
Posted by: Rick James
Date: September 22, 2010 07:57PM

A table with only 124K rows is not worth partitioning. How big will your real table be?

PRIMARY KEY(id),
INDEX(date_ril)
would let both of your queries optimize nicely.

Options: ReplyQuote


Subject
Views
Written By
Posted
2779
September 21, 2010 04:03AM
Re: Pruning problem.
1559
September 22, 2010 07:57PM
1539
September 23, 2010 03:16AM
1553
September 23, 2010 08:40AM
1449
September 24, 2010 02:24AM
1650
September 28, 2010 10:38AM


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.