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

what are the different type of sql's statements ? : Sql dba

697


What are the key differences between SQL and PL SQL?

850


Is sql a microsoft product?

690


What is a behavioral trigger?

689


What is a function in oracle pl sql?

713






what is the functionality of the function htmlentities? : Sql dba

690


How to run sql functions in pl/sql?

721


what is collation? : Sql dba

796


What are operators available in sql?

779


How do I save the results of sql query in a file?

709


What is sequence in sql?

716


Which is faster truncate or drop?

770


What are the 3 modes of parameter?

862


What is meant by temporal data?

706


Is sql better than excel?

696