1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / swapna vamsi

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 a column in a table?

554

how many sql ddl commands are supported by 'mysql'? : Sql dba

526

What are the 3 modes of parameter?

679

Explain spool.

688

Which sql most popular?

556




How do rank () and dense_rank () differ?

522

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

721

What are actual parameters and formal parameters?

570

Enlist the advantages of sql.

571

What is compiled query?

519

What types of commands can be executed in sql*plus?

552

What is a unique key and primary key and foreign key?

567

What do you think about pl/sql?

533

What is the difference between partitioning and sharding?

528

Why is theta join required?

664