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

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.

what are the receipt types in Po?

2 Answers   Evosys, UST,

---

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

---

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,

---

how will you refer a report column (data column,formula,summery,placeholderr)?

1 Answers  

---

Are you familiar with internet architecture of oracle apps 11i?

0 Answers  

---

HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers  

---

How to register a form and stored procedure in oracle apps

2 Answers   Mastek, TCS,

---

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,

---

How many types of projects are there in project module?

6 Answers   Fujitsu, Tech Mahindra,

---

Can you have two stored functions with in the same name?

3 Answers  

---

what is user exit and wat program do we write in user exit?

4 Answers   iGate,

---

what is the use of format trigger?a

3 Answers  

---