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

What is dynamic sql in pl sql?

0 Answers  

---

What is dense_rank in sql?

0 Answers  

---

I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  

---

How do I run a program in pl sql?

0 Answers  

---

Why do we need unique key in a table?

0 Answers  

---

explain normalization concept? : Sql dba

0 Answers  

---

How do I view a view in sql?

0 Answers  

---

What does an inner join do?

0 Answers  

---

What is sql query optimization?

0 Answers  

---

What are the possible values for the boolean data field?

0 Answers  

---

How is sql used in oracle?

0 Answers  

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---