What is an index and types of indexes. How many number of
indexes can be used per table ?

Answer Posted / swapna vamsi

Indexs are used for the faster retrivel of data.

two types of indexes
Cluster index,unclustered index
we can have one cluster index and uotp 249 cluster indexes
for a table

Is This Answer Correct ?    63 Yes 38 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do foreign keys improve performance?

549


how to include numeric values in sql statements? : Sql dba

563


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1645


How many sql core licenses do I need?

509


Is sql difficult?

747






What are dml commands?

529


What is the difference between delete and truncate statement in sql?

499


How do I enable sql encryption?

519


What is date functions?

577


How do you concatenate in sql?

552


What is the file extension for sql database?

519


How many sql commands are there?

675


How can one get sql*loader to commit only at the end of the load file? : aql loader

572


What is a sql statement?

535


Is keyword pl sql?

562