How to Identify Real Versus Automatically-Created Indexes

I’ve noticed a lot of entries in the sysindexes table for indexes that I didn’t create. I heard that they’re not real indexes but statistics that the SQL Server query optimizer has automatically created. How can I tell if an index is “real” or one automatically created by SQL Server?

Read More - Register for Free Membership