I have one query I have partion table and partitioning is done in dates but due to some reasons , i need yo fetch the data using some other dates ..data is in millions and taking around one hour ..however before that when I was using partitioning date , it was taking only 20 min....any alternate way to do this ??