How to generate more Logical Reads

(With my tongue starting to feel a little tired …)

Mmmm, there’s a table that the application is accessing extremely frequently, called R_DUMMY. I wonder what data it contains?

SQL> SELECT dummy_key FROM r_dummy;

DUMMY
-----
DUMMY

Mmmm, that looks familiar, doesn’t it? It’s almost like the DUAL table, isn’t it?

 

FAST DUAL optimisation? We don’t need no stinkin’ FAST DUAL optimisation.

Sigh.

Published
Categorized as Oracle

2 comments

Leave a comment

Your email address will not be published. Required fields are marked *