I have a table partitioned on DATE column with INTERVAL '1' month.I have the data for Jan and Feb months in their own partitions.
Suppose I queried the data selecting the two months data and it took 10 minutes.Now If i query only Feb month data,How much would it take? Is it 10 mins or less tahn 10 mins(bcoz accessing one partition been reduced)
Ideally it should take less time if you query for a month. What is the data volume you have for both the months?