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.
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