Zeal-DBA (4/15/2013)
what if i create so many indexes in a database, on each and every table small or large...?
You slow down data modifications, increase the size of the database, increase the size of the backup, increase the time to maintain those indexes, increase the time to run backups and restores...
Create useful, necessary indexes, not random ones everywhere.
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