What is an index as defined in oracle, Database Management System

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







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
Related Questions
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 ? Distributed System - A distributed system consists of a number of processing parts in which are interconnected through a computer network and in

define anomalies and different types of anomalies with example

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 from one or more tables ? JOIN data manipulation command combines the records from one or more tables.

what does glory be mean

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? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

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 ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu