Answer / sa123

For good performance Index is required.
Consider the case of a very large table (20,000,000 rows)
to which new records are added daily (usually about 1,000
of them). Every night, you need to report these additions
on an audit trail. Rather than scan the whole table looking
for changes, you will want to use an index over the
TRANSACTION_DATE column. But the index would need to be
huge. This is a case in which your index is over the entire
table, although you are actually interested only in the
1,000 or so records that were added today. The actual index
is physically many times larger than it needs to be, and it
uses many more disk I/Os to traverse the binary tree to the
leaf data.

Answer / samar singh

Index by tables are composed of two components
1)primary key of binary_interger
2)column of scalar or record type

and used for increasing the size dynamically.

Answer / opulentus

opulentus

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

How delete all records from table in sql?

0 Answers  

---

What is type and rowtype in pl sql?

0 Answers  

---

What is user define exception and example

1 Answers   HP, KP,

---

---

What are the types of records?

0 Answers  

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

When can we use the where clause and the having clause?

0 Answers  

---

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

---

How to install oracle sql developer?

0 Answers  

---