RE: Query-rewrite-* params: still required to use FBI's?

From: FMHabash <>
Date: Wed, 4 Mar 2009 09:50:37 -0500
Message-ID: <>

This is excellent follow up. Thank you all. One more case closed.

-----Original Message-----

From: Christian Antognini <> Sent: Wednesday, March 04, 2009 3:38 AM
To: FMHabash <>
Subject: RE: Query-rewrite-* params: still required to use FBI's?


Excerpt of page 391 of TOP:

Up to Oracle9i Release 2 patchset, in order to create a function-based index, a user requires
the system privilege query rewrite. In addition, the query optimizer takes such an index into consideration
only when the initialization parameter query_rewrite_enabled is set to TRUE and the initialization parameter
query_rewrite_integrity is set to either trusted or stale_tolerated. As described in MetaLink
note "Bug 2799028" (2799028.8), these requirements are no longer necessary as of patchset

Chris Antognini

Troubleshooting Oracle Performance, Apress 2008

-- Received on Wed Mar 04 2009 - 08:50:37 CST

Original text of this message