We have a complex query that returns results in 45 secs when run from the 01-05-11 to the 31-05-11, but when it is extended to the 01-06-11 it runs indefinately... THe tables are partition by month...
I think the indexes are aligned as they where created with the DB... I am assuming an additional one has been created and is not aligned,
How can I make sure the indexes are aligned with the table partitions
or can anyone think of anything else that could be causing this problem ?