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.

cursor 1 and cursor 2 are there did you open both the cursors at a time or not?

2 Answers   Infosys,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,

---

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

2 Answers  

---

what is the difference between varchar and varchar(2)?

4 Answers  

---

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

6 Answers   HCL,

---

what are the types of interfacing?

3 Answers   TCS,

---

In what situation u create the BPA.

2 Answers   Accenture,

---

IN WHICH MODULE THE LEGAL ENTITY COMES?

5 Answers  

---

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

---

What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  

---