What is Index and different types of Indexes?

Answer Posted / muralidharan

Index is used to fetch the data in a reliable and fast
manner and the types of index avalilable are clustered
index and non clustered index.

Murali
dharanmu@yahoo.com

Is This Answer Correct ?    13 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to split the print reviewer into more than one region ?

2020


What is a system tablespace?

795


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1478


Explain oracle data types with examples?

752


How can we find out the current date and time in oracle?

819


What to do if dba lost the system password?

823


What is Undo Management Advisor in Oracle?

794


What happens if you lost a data file?

791


What is a dynamic performance view in oracle?

779


How to put more than 1000 values into an oracle in clause?

766


What are the original export and import utilities?

760


What is max rowid in oracle?

763


What is a trigger and what are its types in oracle?

744


How to calculate date and time differences in oracle?

750


List out the types of joins.

837