What is an Index ?

Question

Hello guys,   

What is an Index ?

How it is implemented in Oracle Database ?

Please give me your feedback...........I am waiting for your feedback

Thanks in advance

Answer 1

An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman

Answer 2

A DATABASE OBJECT WHICH IDENTIFIES EACH FIELD OF A COLOMN UNIQUELY AND IMPROVES THE PERFORMANCE OF A QUERY DURING SELECT STMTS