What is an Index , Types od index why we are use index.

Answers were Sorted based on User's Feedback



What is an Index , Types od index why we are use index...

Answer / venkatesh

Index is a performance tuning method by using this we can
retrive records fastly index types are

- unique index
- non unique index
- bitmap index
- B-tree index

Is This Answer Correct ?    5 Yes 0 No

What is an Index , Types od index why we are use index...

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

Post New Answer

More Oracle Apps Technical Interview Questions

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

12 Answers   TCS,


Can function be overload?

4 Answers  


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

1 Answers  


is it possible to run the interface without using oracle apps?

0 Answers  


What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,






is it possible to run the interface without using oracle apps?

2 Answers   Accenture,


what is the standard program for blanket po to process data from interface table to bace table

3 Answers   Zensar,


Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,


What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,


Tell me how to find the custom directory in front end?

0 Answers  


diff between key and descriptive flexfield.

4 Answers   Convergys,


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 ?

2 Answers   Wipro,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)