Partition Access Count

Database

Partition Access Count

I have a weekly agg table holding 15 years of data and it is partitioned by Week. I would like to find the access count by parition to understand how many time we access data older than 5 years.

Is there a way I can look at the Partition access count to get this info or is there any other way you would go about this?

Thanks in advance
1 REPLY
Enthusiast

Re: Partition Access Count

Hi,

Can someone answer this question? 

Thanks,

Dinesh