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
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass