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 |
When a user process fails, what background process cleans up after it?
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
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What is mrc and what is its use? : oracle accounts receivable
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Why more redos are generated when the oracle database is in begin backup mode?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how to write customizations in po
as a technical developer in oracle applications which type errors feced in your experience sofar
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure