Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2007-02-12 : 11:47:45
|
| Hi,The b tree consists of a root, non-leaf nodes and leaf nodes.My question is, For clustered indexes:is the root and non leaf part of the tree stored in-memory? or is it stored on disk or even partially in both? For non-clustered indexes over a heap:is all the b-tree stored in memory? or is it stored on disk or even partially in both?Thank you |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-12 : 11:56:20
|
| All of the above exist on disk (in case you server reboots). SQL Server will only copy those pages that it needs into memory for any operations on the data (read/update). The root pages of the B-Trees will generally be in memory, as that is the starting point of any index seek. Which pages are actually cached on your particular server is dependent on whether there are usable indexes, and how the data is used. |
 |
|
|
|
|
|
Where is the B-tree stored?