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.

in one report using two layout models.if yes how to do

2 Answers  

---

What is the package?

2 Answers  

---

In thet custom.pll what are the events we can write.

2 Answers   IBM,

---

Tell me how to find the custom directory in front end?

0 Answers  

---

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,

---

---

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,

---

I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,

---

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

---

what are the error tables in OM

2 Answers   Fujitsu,

---

How to find which company will be conducted Oracle appa interview? Plz help me

3 Answers  

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

What are the User PARAMETERS in the Reports?

6 Answers   Accenture, CTS,

---