INDEX Usage in SQL SERVER 2008

Question

INDEX Usage in SQL SERVER 2008

@ry@n

SSC Enthusiast

Points: 190
More actions
December 29, 2011 at 12:13 am

#265467

[font="Times New Roman"]
In SQL Server, indexes are organized as B-trees. is there anyway to access this B-trees??
Regards,
Anil Kumar
MCTS
[/font]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

What do you mean by accesing the B-Tree. Every time the query optimizer decides to use an index you will access the B-tree.

If you want to know how many levels the B-tree has you can use sys.dm_db_index_physical_stats.

[font="Verdana"]Markus Bohse[/font]

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

Check the following link:

http://msdn.microsoft.com/en-us/library/ms177443.aspx

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

@ry@n SSC Enthusiast Points: 190 More actions · Answer 3

MarkusB (12/29/2011)
What do you mean by accesing the B-Tree. Every time the query optimizer decides to use an index you will access the B-tree.
If you want to know how many levels the B-tree has you can use sys.dm_db_index_physical_stats.

[font="Times New Roman"]

Dear Markus,

I just need to see how the data is getting stored in the form of B-Tree.

In btwn thanx a lot for your help :-)[/font]

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 4

@ry@n (12/29/2011)
MarkusB (12/29/2011)
What do you mean by accesing the B-Tree. Every time the query optimizer decides to use an index you will access the B-tree.
If you want to know how many levels the B-tree has you can use sys.dm_db_index_physical_stats.
[font="Times New Roman"]
Dear Markus,
I just need to see how the data is getting stored in the form of B-Tree.
In btwn thanx a lot for your help :-)[/font]

In that case the link provided by free_mascot should help you further.

[font="Verdana"]Markus Bohse[/font]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

@ry@n (12/29/2011)
I just need to see how the data is getting stored in the form of B-Tree.

Maybe have a read through this series:

http://www.sqlservercentral.com/articles/Indexing/68439/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

@ry@n SSC Enthusiast Points: 190 More actions · Answer 6

[font="Times New Roman"]

Dear Gail,

Thanx a lot for sharing the link. i hope it can help me.

[/font]