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

Indexed (indexed sequential) file organisation, Indexed (Indexed Sequential... Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows

Datawarehouse, Define a job scheduling strategy that will meet business req... Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Cartesian product, If R1 and R2 are two relations or functions, then the re... If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

Transaction managenment, can you please explain with the help of suitable e... can you please explain with the help of suitable example the difference between conflict equivalence and conflict serializability?

Dbms of company, what should be included in this??? what should be included in this???

Describe drop table command or cascade of sql, Describe DROP TABLE command ... Describe DROP TABLE command of SQL along with both the options - CASCADE and RESTRICT. DROP TABLE command - This command drops the specified table. Dropping a table also dro

Database Design For Inventory, how design database from begining how design database from begining

Assignment topic, assume we have the following apllicationthat model sccer ... assume we have the following apllicationthat model sccer team the games they play and the players inv each teamin the design we want to capture

What is a merge sort, QUESTION (a) Using an appropriate example, explai... QUESTION (a) Using an appropriate example, explain what is a recursive function? (b) Explain in detail the C++ function given below. void search2(int list[],int n,int ele

DBMS, You are managing the following database system: • DBMS: Oracle 11g... You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR manage