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 template?

2 Answers  

---

What are triggers?

3 Answers  

---

Can you differentiate between mediator and osb?

0 Answers  

---

You are working with interfaces if client doesnot give any flat then what will u do?

8 Answers   Wipro,

---

what is the difference between procedure and function

3 Answers   Wipro,

---

How to attach the multiple templates in XML Pub Report?

2 Answers   Intelligroup, KPIT,

---

Tell me how to debug the report?

0 Answers  

---

what are the different types of parameters avialable in reports?

2 Answers   Oracle,

---

what is the use of anchors?

2 Answers   IBM,

---

what are the match approvals in PO?

3 Answers  

---

We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,

---

is it possible to run the interface without using oracle apps?

0 Answers  

---