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

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1904


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2352


what are the API of GL,PO,AP

1767


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16340


8. Supporting AP, AR and GL?

1801






now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

1790


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

716


how to write customizations in po

1189


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2011


how to replace not in with not exist?

3182


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1902


Why more redos are generated when the oracle database is in begin backup mode?

655


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1484


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1484


How to clone the database using RMAN back

1608