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