karthika

• Nov 6th, 2014

 

Indexes are used to fast retrieval of data when there are lakhs of records.
There are 2 types of indexes: Clustered Index & Non-Clustered Indexes.

veerendra reddy

• Jan 24th, 2015

 

index stores only physical adress not only data ,indexe is a data base object,when u created either primary key and unique key in columns index is created automatically same name of constraint name like what ever name u created on constarint that name.and main use of index is at time of retriving the data performance is very fast i mean index column used in where clause

chinnu

• Jan 27th, 2015

 

index is a database object,It stores only physical address never & ever stores the data.

Priya

• Jan 31st, 2015

 

Indexes are used for fast retrieval of data from the table

harsha vardhan

• Feb 2nd, 2015

 

indexes are used to retrieve data from a table that too very fast
for example it can retrieve lakhs of records from table..
and indexes never stores data,it stores only physical address..

kapil

• Feb 3rd, 2015

 

Index is an object. It is used to retrieve data faster from the table. Following are types of indexes in oracle.
Normal Index
Unique Index
Function based Index
Reverse key Index

Manu

• Feb 11th, 2015

 

index is a data base object which is used to fast retrieval of data, index stores physical address of the rows. Main use of index is at time of retrieving the data performance.

Abhijit Musale

• Feb 18th, 2015

 

it is not necessary that adding an index will always help. When u have less no. of records then there is no need to add index. An index is an additional database object to improve the data i/o operations.

lakshmi

• Feb 20th, 2015

 

index is schema object.which is an entry for each value that are appear index column.index used to give a direct access and also increase the performance .

types of indexes:

simple,composite,function based,bitmap,bit treeindex