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

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1570


What are temporal data types in oracle?

586


What do you mean by a deadlock?

507


What is an oracle user role?

555


How to create a new table by selecting rows from another table?

537






Explain the different normalization forms?

577


What is MTTR advisor in Oracle?

595


Can we connect to ORACLE db using Windows Authentication?

705


What are joins, explain all types of joins?

1704


Can you have more than one content canvas view attached with a window ?

1806


What are the different types of record groups in oracle? Explain each of them

585


What is a package in oracle?

556


Explain oracle insert into command?

614


How to write numeric literals in oracle?

596


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

552