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 the use of placeholer column?

3 Answers  

---

Can you have two stored functions with in the same name?

3 Answers  

---

how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,

---

what is back order in OM

4 Answers   IBM, Oracle,

---

can we get profile values in report without using user exists is it possible how?

0 Answers   Cap Gemini,

---

---

what type of testing u r doing?

2 Answers   Convergys,

---

oracle apps architecture

1 Answers   TCS,

---

when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

---

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,

---

In interface how u find errors and how to solve. How to fix it?

3 Answers  

---