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 invoke the data pump export utility?
What is pragma autonomous transaction in oracle?
Explain the importance of .pll extension in oracle?
What is java oracle used for?
How to run queries on external tables?
What are advantages of dateset in datastage?
What is a partition in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is a sub query? Describe its types?
Is truncate autocommit in oracle?
How to invoke the original export import utilities?
What is key preserved table?
how do u setup a replication site?
Why packages are used in oracle?
How do we get field detail of a table?