views:

47

answers:

1

The dynamic management views of SQL Server 2005 can give usage information about table indexes. Is there a similar method for getting usage information about column statistics? In specific, I'm curious if some of the older column statistics I've created are still being used. If not, I'd like to delete them.

+1  A: 

no there isn't. there are however sys.stats_columns and sys.stats catalog views

Mladen Prajdic