Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by Oracle MEDIA RECOVERY?
What is auto invoicing? Explain : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
3. Steps in UAT?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is the difference between conversions and interfaces? : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
What Are Cross Validation & Adi?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?