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 mrc and what is its use? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
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 would you determine who has added a row to a table?
what is difference between inner join & nested query or subqueries
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
types of receipts and detail desription about recipts and tables effected by receipts?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
which one is currently in used software cmpanies.
What is Tax Categories?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Explain how to close periods in ar. : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is the importance of batch source set up in ar? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
