Three type of indexes in sql 1.Clustered 2.Non-clustered 3.Unique

How many types of indexes are there in SQL Server?

Question Posted / rohti nanda

Answer Posted / rohti nanda

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is data source view or dsv? : sql server analysis services, ssas

567

Can sql servers linked to other servers like oracle?

552

How to defragment table indexes?

558

What is the osql utility?

552

What is sql server schema compare? How we can compare two database schemas?

575

What is the federation in sql azure?

What is the difference between for trigger and after trigger?

556

What is tabulation?

568

What are transactions and its controls?

624

How will you find out if there are expensive SQL statements running or not?

591

Define self join?

637

What are the different acid properties?

638

Define full outer join in sql server joins?

509

Explain what is the difference between a local and a global temporary table?

517

difference between Clustered index and non clustered index ?

589