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
When do you get a .pll extension in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain the difference between a procedure and a function? What do you understand by those terms?
What privilege is needed for a user to create indexes in oracle?
What are the execution control statements?
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.
How to export several tables together?
How to open and close an explicit cursor in oracle?
Why is oracle so popular?
Explain the use of show option in imp command.
What is a package in oracle?
How to loop through data rows in the implicit cursor?
Why does for update in oracle 8 cause an ora-01002 error?
State some uses of redo log files?
What is a procedure in oracle?