The major drawback of indexes is its storage.Indexes are stored on the Disk
, and the amount of space required will depend on the size of the table, and the number and types of columns used in the index. Disk space is generally cheap enough to trade for application performance, particularly when a database serves a large number of users. To see the space required for a table, use the sp_spaceused
system stored procedure in a query window.
Exec sp_spaceused tablename
This returns amount of space used by the data and all indexes associated with the table.
Sometimes u observe that the indexsize is more than the table data size and it depends on the columns,data types and number of indexes of the table.
DharanidharWinod, if this helps please login to Mark As Answer. | Alert Moderator