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.