how clustered index stored in a memory

Posted by Johnseelan under Sql Server on 4/6/2011 | Points: 10 | Views : 3207 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

how clustered index stored in a memory
&
one table how many indexes can have
please any one give me the answer.

Thanks
john

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	Thanks Pandiyan.... Johnseelan, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts