What is index? How many types of indexes?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ruchi
index is a data structure used for fast retrival of data.
| Is This Answer Correct ? | 7 Yes | 3 No |
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
What view would you use to look at the size of a data file?
as a technical developer in oracle applications which type errors feced in your experience sofar
what are the API of GL,PO,AP
Give two examples of how you might determine the structure of the table DEPT.
what is diff between pre insert,on insert,post insert triggers?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
Difference between negative and positive adjustments : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
A scenario for amount correction & how to use amount correction functionality in AP invoices