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.

oracle apps architecture

1 Answers   TCS,

---

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?

2 Answers  

---

How can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,

---

in procedure how to return a value

3 Answers  

---

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  

---

in procedure how to return a value

2 Answers   Wipro,

---

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

0 Answers   Accenture,

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---

what is the database size you used?

1 Answers   FIS,

---

In sequence i want to 11 and 15th values how we will write?

0 Answers  

---

How can you achieve loose coupling in soa framework?

0 Answers  

---