Question about intermediate level

Good Afternoon.

I have one question about clustered index.

The clustered index have one architeture such as be-tree...

What's the intermediate level on the clustered index?

Thanks..

I'm not sure that I fully understand your question.

The entire index structure is an 'inverted B-Tree' structure.

|||

Yes a 'inverted B-Tree' structure

But I read that any index levels between the root node and the leaf level is called intemediate level.

What's the intermediate level?

What does he do?

Thanks...

|||

Fernando,

The 'intermediate level' is just part of the indexing structure.

Imagine having a catalog of books at the biblioteque. To look up a subject, the card catalog would direct you to a book. Then the book index would direct you to a page or pages. consider the intermediate level similar to the book index.

For a better discussion of B-Tree indexing, refer to Books Online, Topic: B-Tree. (There is a nice little diagram there.)

|||

It's clear for me now....The intermediate level is a part of the indexing structure that direct you to a page.

Thanks for answering