I have an application database where we stored historical data with day paritioned.
Task is to findout how much history data being accessed by downsteam applications with partition column?
eg: lets say if a table has 5 years of data, how to determine if qureies are accessing all the history info or only for few years ? any means ?
Appreciate your quick help?