| Author |
Topic |
|
Jude_Aj
Starting Member
22 Posts |
 Posted - 2009-07-22 : 02:38:22
|
| Hi, I wanted to know, if an index page can contain records of a table.I have got an mdf file (SQL server 2005) with 26 tables. The records of these page are stored in an index page(Page type = 2).Thanks,Jude |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-22 : 04:16:05
|
| I don't understand what you are asking, please try to elaborate. If you are asking whether an index stores records, then no, it stores pointers to the records. Other than that, I can't fathom what you are asking. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-22 : 05:29:49
|
Are you talking about clustered index?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Jude_Aj
Starting Member
22 Posts |
Posted - 2009-07-22 : 05:52:51
|
| Is there a possibility that an index page of a table contain records ofthe table if there is clustered index created for that table. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-22 : 05:55:31
|
A clustered index holds the complete data.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-22 : 06:02:09
|
| No, a clutered index contains the data for the clustered index column, not the complete data for the table. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-22 : 07:37:07
|
Yes, of course!A clustered index holds the complete data.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-22 : 07:39:44
|
Maybe it could be expressed more precisely.But in simple words it is like I have posted.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-22 : 07:54:44
|
| HiIf this clustered index, the leaf nodes contain the data pages of the underlying table. The root and intermediate level nodes contain index pages holding index rows. Each index row contains a key value and a pointer to either an intermediate level page in the B-tree, or a data row in the leaf level of the index.-------------------------R.. |
|
|
|
|
Index Page