What is an Index , Types od index why we are use index.
Answers were Sorted based on User's Feedback
Answer / 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 |
What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter
Can function be overload?
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions
is it possible to run the interface without using oracle apps?
What is MO operating units. Why it need to to set this and where .
is it possible to run the interface without using oracle apps?
what is the standard program for blanket po to process data from interface table to bace table
Is that Possible To create package without Specification , If Yes Give any Examples
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
Tell me how to find the custom directory in front end?
diff between key and descriptive flexfield.
Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?