different kind of Indexes for different tables

Hi ,
I read in Oracle that each table's can have it's own kind of indexes e.g IOT
, BitMap , B-Tree for different purposes used by Application.
Is there such function(s)/options in SQL Server ?
appreciate ur advise
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200602/1Indexes in MS-SQL Server are in B-Tree structure.
But you can fine tune them for your needs with some options (like the
fill factor). take a look at the "CREATE INDEX" in the BOL.|||Hi ,
tks for ur advise
rdgs
amit.tzafrir@.gmail.com wrote:
>Indexes in MS-SQL Server are in B-Tree structure.
>But you can fine tune them for your needs with some options (like the
>fill factor). take a look at the "CREATE INDEX" in the BOL.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200602/1