adspace


Explain an index?

Answer Posted / Akhilendra Kumar Pandey

An index is a database structure used to speed up the retrieval of rows from a table based on one or more columns. It works by storing the value of the indexed column(s) and a reference to the row's location in the table. When a query uses the indexed column(s), Oracle can quickly find the relevant rows without having to scan the entire table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle latest version?

1174


How to start an oracle instance?

1103


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956


Design database draw er diagram for a certain scenario ?

4656


How to write a left outer join with the where clause in oracle?

1155


How to use values from other tables in update statements using oracle?

1158


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

1115


How to select all columns of all rows from a table in oracle?

1132