What is an Index , Types od index why we are use index.
Answer Posted / ravi saini
An index is a performance-tuning method of allowing faster
retrieval of records. An index creates an entry for each
value that appears in the indexed columns. By default,
Oracle creates B-tree indexes.
Create an Index
The syntax for creating a index is:
CREATE [UNIQUE] INDEX index_name
ON table_name (column1, column2, . column_n)
[ COMPUTE STATISTICS ];
UNIQUE indicates that the combination of values in the
indexed columns must be unique.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different components you should consider while defining a responsibility in oracle apps?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Do you know what is applysys in oracle application database schema, what is apps?
tell me the scenarios of the independent in reports
where to define interorganization transaction charges and what are the different options?
How can we import the data into a database using sql * loader?
how can i print random rows in plsql table
What are the different components of soa suite?
What are the Standard Reports and Forms in HRMS?
Plz anybody send me Technical specification for AP Interface
what is pay run id ?
how do you describe O2C along with tables
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
what is the differences between internal requisition and internal sales order?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?