Re: Select cannot use partitioning correctly?

[Nanda kishore Toomula]

Hi

try explain partition

example

explain partition select * from t_pgv_v1_map_url_id where ftime between '2009-08-01' and '2009-09-01' and map_id = 1003200;

my advice is do range partition based on month of the date

say for example

PARTITION BY RANGE (month(ftime)) because this is more sensible and only 12 partitions and no redundancy


Cheers
Nanda