What is index? How many types of indexes?
- 2 Answers
- 11279 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 IS CARTESIAN PRODUCT?
Explain about party and customer in ar : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What is chargeback invoice? How do we create it? : oracle accounts receivable
How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
What background process refreshes materialized views?
can we drop dual table
What type of index should you use on a fact table?
How would you go about generating an EXPLAIN plan?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable
Oracle General 
