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 procedure and function

4 Answers  

---

where u do setup of operating unit?

1 Answers   TCS,

---

Which module is not in multiorg

6 Answers   HCL, Wipro,

---

Can you define an erp system?

0 Answers  

---

what is pay run id ?

0 Answers  

---

why r u move in the cus_top only why not move another top

4 Answers   Wipro,

---

What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,

---

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

---

How we print the multi language in report?can any one give me step bye step explanation.

2 Answers   HCL, IBM, Tech Mahindra,

---

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---

What is P2P cycle.

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

---

I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,

---