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 difference between varchar and varchar(2)?

4 Answers  

---

what is aim methodolozy

1 Answers  

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

0 Answers  

---

What are ad-hoc reports?

1 Answers  

---

In Per_all_people_f table what is the significance of '_f ' ?

6 Answers   HCL,

---

can we write sql statement in Format trigger?

4 Answers  

---

What are do's and dont's of Interface?

0 Answers  

---

Explain oracle apps architecture.

0 Answers  

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

What and Who is the best Institute or Trainer for Oracle Apps Technical ?

2 Answers  

---

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers  

---

In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,

---