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 / rm thirunavukkarasu

Answer Posted / rm thirunavukkarasu

Index is used to Retrive the Information in efficient
manner. And query processor perform reliably.

There are 3 types of Index namely
*Cluster based Index
*Non Cluster based Index
*Noncomposite Index
*Compositive Index
*Unique Index

For more info adt sql plz visit www.thiruna.blog.com

Is This Answer Correct ?    8 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What if we write return in procedure?

785

What is an invalid partition table?

562

when is the use of update_statistics command? : Sql dba

500

What is the use of procedures?

539

define sql update statement ? : Sql dba

570




Can you have more than one key in a database?

507

Can we use delete in merge statement?

512

How do you delete duplicates in sql query using rowid?

533

Is sql similar to python?

532

What are inbuilt functions in sql?

595

How to fix oracle error ora-00942: table or view does not exist

567

Which is better join or subquery?

604

Is sql sequential or random?

535

What is sql lookup?

511

Can there be more than one function with a similar name in a pl/sql block?

541