|
|
Пишет Abu Antos' (![[info]](http://lj.rossia.org/img/userinfo.gif){kind=small} syarzhuk)@ 2012-01-30 14:25:00 |
 |
|
 |
|
|
|
|
|
|
 |
|
 |
Buddhist databases optimize one-row tables!
DUAL was originally a table and the database engine would perform disk IO on the table when selecting from DUAL. This disk IO was usually logical IO (not involving physical disk access) as the disk blocks were usually already cached in memory. This resulted in a large amount of logical IO against the DUAL table.
Later versions of the Oracle database have been optimized and the database no longer performs physical or logical IO on the DUAL table even though the DUAL table still actually exists.
http://en.wikipedia.org/wiki/DUAL_t
DUAL was originally a table and the database engine would perform disk IO on the table when selecting from DUAL. This disk IO was usually logical IO (not involving physical disk access) as the disk blocks were usually already cached in memory. This resulted in a large amount of logical IO against the DUAL table.
Later versions of the Oracle database have been optimized and the database no longer performs physical or logical IO on the DUAL table even though the DUAL table still actually exists.
http://en.wikipedia.org/wiki/DUAL_t
Добавить комментарий:
