To drop the stale stats

Database
Enthusiast

To drop the stale stats

Hello,

I need to check whether stats defined on the tables are really used by the optimizer or just ignored. Since collect stats are more CPU consuming , need inputs on this to check all the stats defined on the tables and to remove those are not useful.

Regards