What is an INDEX as defined in ORACLE?

Indexes in Oracle - Index is classically a listing of keywords accompanied through the location of information on a subject. Instead, an index can be viewed as an auxiliary table that contains two fields: the key and the location of the record of in which key. Indexes are used to improve the performance of the search operation. Indexes are not strictly essential to running Oracle, they do speed the procedure.

Posted Date: 5/10/2013 3:27:37 AM | Location : United States

Ask an Expert

Related Discussions:- What is an index as defined in oracle, Assignment Help, Ask Question on What is an index as defined in oracle, Get Answer, Expert's Help, What is an index as defined in oracle Discussions

Write discussion on What is an index as defined in oracle
Your posts are moderated

Write your message here..

Related Questions

What is dml, What is DML (Data Manipulation Language)? This language th... What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM

What is distributed system, What is Distributed system ? Distributed S... What is Distributed system ? Distributed System - A distributed system consists of a number of processing parts in which are interconnected through a computer network and in

Anomalies, define anomalies and different types of anomalies with example define anomalies and different types of anomalies with example

Explain the fourth normal form, Fourth Normal Form (4NF) When attribut... Fourth Normal Form (4NF) When attributes in a relation have multi-valued dependency, further Normalization to 4NF and 5NF are needed. Let us first find out what multi-valued d

Which data manipulation command combines the records, Which data manipulati... Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.

Glory be, what does glory be mean what does glory be mean

What is advantage of two-way association, What is advantage of two-way asso... What is advantage of two-way association? Two-way association advantages are following: a) Independent of the classes. b) Useful for existing predefined classes that are

What are the states of transaction, What are the states of transaction? ... What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

Define identify relationship, Define identify relationship? Identifyin... Define identify relationship? Identifying relationship: An identifying relationship means in which the child table cannot be uniquely recognize without the parent. For exampl

What is disadvantages of dbms, What is Disadvantages Of DBMS ? 1. Cos... What is Disadvantages Of DBMS ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu