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,

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

|||

Hi, Ryan, thanks a lot for your guidance.

With best regards,

Yours sincerely,