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 is organization id

3 Answers  

---

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

---

Give a brief overview on OrderManagement.

1 Answers   Zensar,

---

What r the validation done in ap inbound ?

2 Answers   Questam,

---

what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,

---

FLEX FIELDS?

2 Answers  

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

what are centralized and decentralized level of control of item attributes?

2 Answers   Scan Steel,

---

What do you understand by soa and what are the benefits of using this architecture?

0 Answers  

---

While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,

---

List the types of flexfield?

0 Answers  

---

What is OM Cycle and What do u mean by Alternate Item

3 Answers   IBM,

---