Where are the indexs are stored in SQLServer

Posted by Winod under Sql Server on 11/1/2012 | Points: 10 | Views : 814 | Status : [Member] | Replies : 2
Hi,

When we create index on a table where are they stored ,in the same table or in different place.

Thanks.




Responses

Posted by: Naraayanan on: 11/2/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
Check this link
http://odetocode.com/articles/70.aspx

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Winod, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Dharanidhar on: 11/2/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Winod,
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.

Regards,
Dharanidhar

Winod, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response