About types of indexes in SQL server ?

Answer Posted / pandian

There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is collation sensitivity?

553


What are window functions in sql server?

513


How do I find the default sql server instance?

525


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

517


where can you add custom error messages to sql server? : Sql server administration

585






How to update a field in SQL after ALTERING a row?

690


What happens when the SQL Azure database reaches Max Size?

90


Which tools are available to manage SQL Azure databases and servers?

93


Why truncate is ddl command?

516


What do you understand by check constraint in sql server?

485


Do you know what guidelines should be followed to help minimize deadlocks?

538


Why union all is faster than union?

510


Explain the truncate command?

524


How to sort query output in descending order in ms sql server?

551


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

730