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 |
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
what is domain in database and its benefits?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Explain how to close periods in ar. : oracle accounts receivable
Describe what redo logs are.
What do you mean by hz_ in customer tables? : oracle accounts receivable
WHAT IS CARTESIAN PRODUCT?
What is the Symbol use for Inner Join
Can we modify approve purchase order?if yes what is navigation?
How do you resize a data file?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
HOW TO SPOT AHIERARCHY?