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 pl sql quora?
What is execute immediate?
What are the two virtual tables available at the time of database trigger execution?
what is the command line end user interface - mysql? : Sql dba
What are sql functions? Describe the different types of sql functions?
What is function and procedure in pl sql?
What is mutating error in pl sql?
Which are the different types of indexes in sql?
What are different types of sql commands?
How to pronounce postgresql?
How can I tell if sql is running?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How many sql statements are used?
What are the various restrictions imposed on view in terms of dml?
What are analytical functions in sql?
