What is index? How many types of indexes?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ruchi
index is a data structure used for fast retrival of data.
| Is This Answer Correct ? | 7 Yes | 3 No |
deference between & and &&
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
types of receipts and detail desription about recipts and tables effected by receipts?
statement string in open is null or 0 length ORA-40735
how to write customizations in po
What is chargeback invoice? How do we create it? : oracle accounts receivable
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
what are basic modules required to implement oracle application in any oraganisation?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?