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: