why should required for Indexed by table in pl/sql
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 8 Yes | 2 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
What is the syntax to add a record to a table?
what is sql.
Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL
How many commands are there in sql?
what are the limitations of identity column? : Transact sql
What is the difference between sql and t sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How many databases can sql express handle?
what is a materialized view? : Sql dba
How to start the command-line sql*plus?
I have a table .in the table 100 recored is there .we have get the single row with out using clause..
Is ms sql traffic encrypted?