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


Please Help Members By Posting Answers For Below Questions

How to invoke the data pump export utility?

574


What is pragma autonomous transaction in oracle?

532


Explain the importance of .pll extension in oracle?

561


What is java oracle used for?

533


How to run queries on external tables?

579






What are advantages of dateset in datastage?

1757


What is a partition in oracle?

551


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1575


What is a sub query? Describe its types?

553


Is truncate autocommit in oracle?

647


How to invoke the original export import utilities?

512


What is key preserved table?

572


how do u setup a replication site?

1508


Why packages are used in oracle?

552


How do we get field detail of a table?

635