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
what is the link between suppliers and banks in ap module in oracle apps? And also query?
What do you mean by Oracle MEDIA RECOVERY?
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.
how to replace not in with not exist?
What is db_recovery_file_dest in oracle? When do you need to set this value?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What is an Oracle database Full Backup?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
difference of using cursor for loop and open,fetch,close.which one is better
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
can we use lexical perameter in oracle plsql if yes how
what are basic modules required to implement oracle application in any oraganisation?
What is Tax Categories?
please send me oracle pl/sql exp resume. and also faqs...