Dropping Statistics


Dropping Statistics

Hi All,

I am facing performance issues when queries are hitting few particular tables.Some of these tables are huge and hence it can be undertood but there are also a few tables are are not so big but have a lot of STATS on them( HELP STATS on this returns 50 rows ) .

I am not sure if too many stats is the issue here but i always wanted to know the best approach if thats the case.

-How can we decide if a table has too many stats that spoils the purpose of stats.

-how to identify what stats to drop if thats the case.

- STATS ON (X,Y,Z) AND STATS ON (X,Y) ---> does any of this affect the other

Any other information to keep in mind in the aspect of too many stats or dropping stats is highly appreciated.