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
How to convert a date to char in oracle? Give one example.
What is where clause in oracle?
what are archived logs?
What is varray?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to initialize variables with default values?
How to retrieve data from an explicit cursor?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to use select statement to count the number of rows in oracle?
Can we insert data in view oracle?
Is postgres faster than oracle?
Will you be able to store pictures in the database?explain.
Explain user account with reference to oracle.
What language does oracle use?
How to export several tables together?