MySQL Forums
Forum List  »  Partitioning

Re: After partition also select is scanning all the partitions - need help
Posted by: Venkat V
Date: September 16, 2010 09:45PM

Hi

Table has data from 201008 to 201009 till date.

But when we give the particular date, it is scanning all the rows.

a) Do we need to give any other restriction ?.
b) am i missing anything in create partition statements ?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: After partition also select is scanning all the partitions - need help
1754
September 16, 2010 09:45PM


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.