MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: After partition also select is scanning all the partitions - need help
Posted by: Rick James
Date: September 16, 2010 08:51PM

All the rows in the partition have the same date (Date='2010-09-10') and you have not given any further restrictions, so the SELECT will scan (and deliver) all the rows in that partition.

partitions: PART_20100910000000
Says that it will scan only the one partition

This cannot be trusted as much:
rows: 5379

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
After partition also select is scanning all the partitions - need help
3909
Venkat V
September 13, 2010 08:50AM
Re: After partition also select is scanning all the partitions - need help
1962
Rick James
September 14, 2010 08:20PM
Re: After partition also select is scanning all the partitions - need help
2198
Venkat V
September 16, 2010 07:06PM
Re: After partition also select is scanning all the partitions - need help
2045
Rick James
September 16, 2010 08:51PM
Re: After partition also select is scanning all the partitions - need help
1964
Venkat V
September 16, 2010 09:45PM
Re: After partition also select is scanning all the partitions - need help
1980
Rick James
September 16, 2010 10:00PM
Re: After partition also select is scanning all the partitions - need help
1941
Venkat V
September 21, 2010 12:17AM
Re: After partition also select is scanning all the partitions - need help
2003
Rick James
September 21, 2010 04:18PM
Re: After partition also select is scanning all the partitions - need help
2005
Venkat V
September 24, 2010 06:14AM
Re: After partition also select is scanning all the partitions - need help
2085
Rick James
September 24, 2010 10:06PM
Re: After partition also select is scanning all the partitions - need help
2295
Venkat V
September 24, 2010 11:33PM
Re: After partition also select is scanning all the partitions - need help
2019
Rick James
September 25, 2010 01:27PM
Re: After partition also select is scanning all the partitions - need help
1997
Mattias Jonsson
September 28, 2010 10:31AM


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.