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.

how do you describe O2C along with tables

0 Answers   TCS,

---

I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,

---

diff between key and descriptive flexfield.

4 Answers   Convergys,

---

how to make a parameter optional in the query?

2 Answers   Wipro,

---

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,

---

Define MultiOrg Structure

5 Answers   Convergys,

---

Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

5 Answers   Deloitte, IBM,

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---

In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,

---

in ap_terms table what data will be stored

2 Answers   Wipro,

---

What is multi org?

6 Answers   Accenture, CTS,

---

What is SET-OF-BOOKS?

3 Answers  

---