Difference between accessing single Partition and Multiple partitions

Database
KVB
Enthusiast

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)

1 REPLY
Enthusiast

Re: Difference between accessing single Partition and Multiple partitions

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?