luckysql.kinda (7/22/2009)
Thanks Gila. Is column statistics also needful?
What do you mean by 'needful'?
They're not a deprecated feature, they're essential for the optimal performance of the query engine.
Check Books Online for more details on statistics
MS should remove sysindexes otherwise.
The sysindexes view is deprecated and will be removed in a future version of the product. It's only included for backward compatibility with SQL 2000
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability