Tuesday, June 1, 2010

sys.indexes vs sysindexes -- Explanation

Generally everybody use both the commands, here is the explanation.

sysindexes -- compatibility views

sys.indexes -- catalog view

Generally we should avoid using sysindexes kind of compatibility views. Microsoft keep this views is becoz to make backward compatibility while migrating from one version to another version.

No comments: