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

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,


Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,


HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  


what is lexical parameter?

3 Answers   TCS,


What are the Major differences bteween key flexfields ,descriptive flexfields

4 Answers   Sierra Atlantica, TechBulls,






Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  


what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,


what are the error tables in AP?

6 Answers  


What is the concept of soa governance?

0 Answers  


what is trace file? what is the use of that?

4 Answers  


what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,


Hi Experts How to Create a purchase order without a requisition ?

6 Answers   Amdocs, KPMG, Oracle,


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)