What is an Index ? How it is implemented in Oracle Database ?

Answer Posted / ankur jain

An Index is nothing, it is something like the index behind in your text book, using index we can find any topic in our text book very fast,, hence database index is also like that, oracle engine uses this index to find any particular row quickly..
This is automatically created when you create the primary key during creation of table..

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do you get a .pll extension in oracle?

646


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1846


Explain the difference between a procedure and a function? What do you understand by those terms?

587


What privilege is needed for a user to create indexes in oracle?

550


What are the execution control statements?

585






1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1578


How to export several tables together?

535


How to open and close an explicit cursor in oracle?

549


Why is oracle so popular?

544


Explain the use of show option in imp command.

601


What is a package in oracle?

538


How to loop through data rows in the implicit cursor?

517


Why does for update in oracle 8 cause an ora-01002 error?

521


State some uses of redo log files?

528


What is a procedure in oracle?

589