how clustered index stored in a memory

Posted by Johnseelan under Sql Server on 4/6/2011 | Points: 10 | Views : 2079 | Status : [Member] | Replies : 2
how clustered index stored in a memory
&
one table how many indexes can have
please any one give me the answer.

Thanks
john




Responses

Posted by: PandianS on: 4/6/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi John

1. Clustered data will be stored in "Leaf level" / "Leaf Node" of the B-tree structure of the index.
2. So, The actual data will be physically sorted and stored in Leaf Node itself of the B-tree structure.
3. Upto SQL 2005, A table can have 1 Clustered & 249 Non-Clustered indexes (250 Indexes).
4. SQL 2008 Onwards, A table can have 1 Clustered & 999 Non-Clustered indexes(1000 Indexes).

Cheers


Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

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

Posted by: Johnseelan on: 4/6/2011 [Member] Starter | Points: 25

Up
0
Down
Thanks Pandiyan....

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

Login to post response