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
What is oracle database 10g express edition?
How to run create database statement?
How to use subqueries with the exists operator in oracle?
what are the advantages of running a database in archive log mode?
How to drop an existing table in oracle?
How to export your connection information to a file?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is a tns service name?
What is the usage of save points in oracle database?
Point out the difference between user tables and data dictionary?
Name the various constraints used in oracle?
What happens if the imported table already exists?
How to convert raw data type into text in oracle? Explain
How is it different from a normal table?
How to rebuild an index in oracle?