All Forums Database
sreedhar26 2 posts Joined 11/07
05 Jan 2015
How to identify the unused stats in a query.

Hi ,
Can anyone tell me, if i have collected stats on every column of all the tables, does this impact in query performance?
if so, how to identify the unused stats ? so that we can drop them to improve perfomance.
example: in our environment , if the table contains 6 columns, then we have collected stats on all the 6 columns + * and the partition(if it is a partition table), is this a bad idea to collect stats on all these columns of a table? 

Raja_KT 1246 posts Joined 07/09
05 Jan 2015

Collecting stats on all columns unneccesarily does not make sense.
I suggest you refer to this similar discussion.
Unused  stats maybe you can compare  pdcr hst logs,tbl infos and get what was not used.

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

ravimans 54 posts Joined 02/14
06 Jan 2015

Hi Sreedhar,
You can collect stats on the index columns & join columns. It's not necessary to collect stats on all the columns in a table.

You must sign in to leave a comment.