July 13, 2003 at 10:46 pm
can anyone specify the disadvantages of indexes
July 14, 2003 at 12:03 am
Hi tcspillai,
quote:
can anyone specify the disadvantages of indexes
I get in the ring first.
There has been a good discussion on that recently. Look at
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=13498
in this thread there is another good link on indexes.
However, first thing that comes to mind on indexes is a consideration of the cost that comes with them. There is always some kind of trade-off between benefits and cost. Tables having indexes need more space on your harddisk. That means your db will grow. Also, DML commands on tables with indexes may take longer and require more processing time, because not only the table data, but also the index data has to be maintained. So, when creating an index you should make sure that benefits outweight the cost.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply