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

What is primary key and example?

965

What is log shipping?

967

How to download and install the scaled-down database adventureworkslt?

999

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

What is query optimization process?

1020

What is a join in sql? What are the types of joins?

1118

What are the types of dml?

994

Why are you getting errors when creating a new odbc dsn?

1234

Which sql server table is used to hold the stored procedure script?

959

What is the osql utility?

985

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1075

What is the distinction amongst delete and truncate?

1082

Explain logical operators in sql server?

1118

what is a join? : Sql server database administration

1261

How to set database to be single_user in ms sql server?

1046