Three Type of indexes in sql 1.Clustered 2.Non-clustered 2.Primary XML

How many types of indexes are there in SQL Server?

Question Posted / chandra bhan singh

Answer Posted / chandra bhan singh

Three Type of indexes in sql

1.Clustered
2.Non-clustered
2.Primary XML

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to create an index on an existing table in ms sql server?

981

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

905

How to connect ms access to sql servers through odbc?

1030

Explain go command in sql server?

1040

What is use of except clause? How does it differ from not in clause?

1020

Do you know how to implement service broker?

928

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1060

what is the sql equivaent of the dataset relation object ?

2027

Describe the left outer join & right outer join. : sql server database administration

999

What is difference between clustered index and non clustered index?

1079

Define clusters?

1086

Explain Geography datatype in SQL Server

1135

How you can find out if an index is useful to the optimizer?

941

Does a sql server 2005 select statement require a from?

1025

What is a data collection table?

1011