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.

2 comments

Leave a comment

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