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 is basic structure of pl sql?

476


Are dml statements autocommit?

526


What makes a good primary key?

490


Does sqlite need a server?

520


Why should I use postgresql?

542






what are properties of a transaction? : Sql dba

542


How do I run sql?

587


What are the possible values that can be stored in a boolean data field?

491


What are the different types of sql commands?

574


What is file based approach?

472


Can we insert data into materialized view?

486


What is form and report?

496


What is difference between primary and secondary key?

488


Is sql the best database?

479


How does rowid help in running a query faster?

945