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 meant by lexical parameter

1 Answers   Wipro,

---

In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  

---

how will u do documentation

2 Answers  

---

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

2 Answers  

---

what is MRC? Why it is needed?

4 Answers   Convergys,

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers   KPIT,

---

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

2 Answers  

---

How to create user and how u attach with responsibility.

2 Answers   Accenture,

---

why we can use synonym?

6 Answers  

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---