Fwd: tuning queries against sys views?

  • From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
  • To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Dec 2010 15:53:18 +0100

Resent due to overquoting ...

---------- Forwarded message ----------
From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
Date: Thu, Dec 2, 2010 at 3:50 PM
Subject: Re: tuning queries against sys views?
To: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
Cc: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>


Check the view definitions of the views involved for your version. Perhaps
they got a RULE hint in there (I recall some do).

You can simply create a clone of them for your use, without that hint.

Stefan

Other related posts:

  • » Fwd: tuning queries against sys views? - Stefan Knecht