Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What do you mean by Oracle MEDIA RECOVERY?

1161


What is auto invoicing? Explain : oracle accounts receivable

1054


Difference between negative and positive adjustments : oracle accounts receivable

1012


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2142


3. Steps in UAT?

2364


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1097


Explain the payment term in ar. : oracle accounts receivable

1055


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2276


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?

1248


What is the difference between conversions and interfaces? : oracle accounts receivable

1120


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

1069


What Are Cross Validation & Adi?

1096


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1074


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1006


What is the difference between recovery and restoring of the oracle database?

1148