What is index? How many types of indexes?
- 2 Answers
- 11159 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 |
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
What is auto invoicing? : oracle accounts receivable
Explain the use of setting GLOBAL_NAMES equal to TRUE.
I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
difference of using cursor for loop and open,fetch,close.which one is better
What is an Oracle database Full Backup?
Give the stages of instance startup to a usable state where normal users may access it.
How would you determine the time zone under which a database was operating?
Olap tools
key flexfield structure
wht r the base tables & primary key for BOM& WIP modules
Oracle General 
