Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is percent sign in sql?
what is subquery? : Sql dba
What are inner and outer joins examples of both?
What is Materialized View? In What Scenario we Use Materialized View?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is self-join and what is the requirement of self-join?
What is the difference between numeric and autonumber?
Name some usages of database trigger?
How would you reference column values before and after you have inserted and deleted triggers?
How to write pl sql program in mysql command prompt?
What are local and global variables and their differences?
what is 'mysqldump'? : Sql dba
How do I view output in sql developer?
How does postgresql compare to oracle/db2/ms sql server/informix?
what is an extent ? : Sql dba
