What is index? How many types of indexes?
- 2 Answers
- 10694 Views
- HCL, I also Faced
- E-Mail Answers
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 |
What are the mandatory setups in setting up a PO in oracle
How would you go about generating an EXPLAIN plan?
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
What is supporting issues GL AP and AR?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
where the dff data will be stored
what are basic modules required to implement oracle application in any oraganisation?
what is diff between pre insert,on insert,post insert triggers?
what is the difference between oracle 81,91,11i
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
can u give guidance abt packages of plsql
Oracle General 
