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 find out what oracle odbc drivers are installed?
What are a query and state the different types of queries and their uses?
Is there a combination of "like" and "in" in sql?
Difference between the “verify” and “feedback” command?
Can we create trigger on materialized view in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is a parameter file in oracle?
What are the execution control statements in oracle?
How to assign values to variables?
How to pass a parameter to a cursor in oracle?
What is oracle in java?
How many types of segments in Oracle?
What is a table in oracle?
Explain what are synonyms used for?
Explain about functional dependency and its relation with table design?