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 to register a form and stored procedure in oracle apps

2 Answers   Mastek, TCS,

---

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

9 Answers   TCS,

---

what is the difference between procedure and function

4 Answers  

---

How to link modules in apps

3 Answers   Zensar,

---

for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  

---

What are profile options?

4 Answers   Accenture,

---

What are different execution methods of executabls?

1 Answers   Genpact, TCS,

---

35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers   Accenture,

---

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,

---

What is procedure?

3 Answers   IBM,

---

can we write sql statement in Format trigger?

4 Answers  

---

what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,

---