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 is the link between suppliers and banks in ap module in oracle apps? And also query?

2472


What do you mean by Oracle MEDIA RECOVERY?

1229


My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2201


how to replace not in with not exist?

3742


What is db_recovery_file_dest in oracle? When do you need to set this value?

1125


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1296


What is an Oracle database Full Backup?

1133


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1092


Explain prerequisites and post activities of oracle database installation

2136


difference of using cursor for loop and open,fetch,close.which one is better

1805


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2957


can we use lexical perameter in oracle plsql if yes how

2315


what are basic modules required to implement oracle application in any oraganisation?

2211


What is Tax Categories?

2113


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

2495