How many types of indexes are there in SQL Server?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of database schema? : sql server analysis services, ssas

605


What is a collation?

598


How to drop an existing table?

559


Mention the differences between local and global temporary tables.

575


Introduction of rollup clause using sum and group by clause?

542






What is the difference between seek predicate and predicate?

594


What do you mean by an execution plan? Why is it used? How would you view it?

538


How to connect of datebase with sql express.?

631


What is catalog views?

614


What are the features of Embedded SQL

681


What is explicit cursors?

563


What is the chart in report?

111


How to delete an existing row with delete statements in ms sql server?

556


What is a partition function in sql server?

539


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

499