Is B-Tree the only Index structure within SQL Server 2005 database?

Hi, All,

Is B-Tree the only Index structure used within SQL Server 2005 database?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

[211 byte] By [Helen999888] at [2007-12-24]

«« Unable to move the position of custom control during design time
»» Animating a canvas?

# 1

Yes, B-trees are the only index structure available. These are used for nonclustered indexes, and for clustered indexes. An unordered "heap" structure is used to store the data in tables with no clustered index.

Thanks,
--R

RyanStonecipher-MSFT at 2007-10-7 >

top of Msdn Tech,SQL Server,SQL Server Database Engine...

# 2

Hi, Ryan, thanks a lot for your guidance.

With best regards,

Yours sincerely,

Helen999888 at 2007-10-7 >

SQL Server

SQL Server Database Engine

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech