Interested to Buy Any Domain ? << Click Here >> for more details...
What is index? How many types of indexes?
- 2 Answers
- 12058 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 |
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.
Compare and contrast TRUNCATE and DELETE for a table.
pl help me, i want oracle HRMS training institute address,in chennai
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
what is sql*loader parameters and where we will use it.
When a user process fails, what background process cleans up after it?
How would you force a log switch?
Describe what redo logs are.
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
What is an Oracle database Full Backup?
Oracle General 
