index is a physical address of the data.Index having 2 types. 1) cluster

What is an index?

Question Posted / nalini

Answer Posted / nalini

index is a physical address of the data.Index having 2
types.
1) cluster index
2)nonclustered index

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the features of Embedded SQL

679

What do we need queues in sql service broker?

526

What is snapshot report?

129

Why do we use non clustered index?

555

What is the latest version of microsoft sql server?

488

What is difference between rownum and rowid?

511

What is the contrast amongst drop and truncate?

562

What is checkpoint process in the sql server?

551

How do use Having,Group by,Group function in SQL?

1360

How to find tables without indexes?

633

What is spatial and temporal data?

536

how to trace the traffic hitting a sql server? : Sql server database administration

1144

What are date and time data types in ms sql server?

529

How to create a new schema in a database?

555

How to return the top 5 rows from a select query in ms sql server?

598