All Forums Database
KVB 124 posts Joined 09/12
08 Jan 2015
Difference between accessing single Partition and Multiple partitions

Hi,
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)

ravimans 54 posts Joined 02/14
09 Jan 2015

Hi KVB,
Ideally it should take less time if you query for a month. What is the data volume you have for both the months?

You must sign in to leave a comment.