adspace


What is index? How many types of indexes?

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


Please Help Members By Posting Answers For Below Questions

please send me oracle pl/sql exp resume. and also faqs...

2588


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2372