What is index? How many types of indexes?

Answer Posted / kishore

Index is a performance tuning method of allowing faster
retrieval of records. Oracle indexing is a standing B-Tree
indexing for fast retrieval.

Syntax: CREATE INDEX EmpInfo ON Employee(EmpID,Emp_Name)

we have two types indexes

1. Clustered indexes
2. Non-Clustred indexes

Is This Answer Correct ?    36 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2105


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

807


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2044


What Are Cross Validation & Adi?

895


Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7697


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1015


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

1753


My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

1952


Difference between negative and positive adjustments : oracle accounts receivable

827


what is semphore explian it?

2484


which one is currently in used software cmpanies.

1877


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2033


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2137


what are the API of GL,PO,AP

1997


Where in the Oracle directory tree structure are audit traces placed?

2379