RE: Query-rewrite-* params: still required to use FBI's?
Date: Tue, 3 Mar 2009 13:00:49 -0500
Message-ID: <49ad704f.0aa5660a.21de.02a1_at_mx.google.com>
Ok. Good thoughts and demo. After doing a review on this topic using 8i,9i,10g, and 11g performance guides, these are my finidings...
1- 8i and 9i explicitly ask for these 2 params to be setup.
2- In 10g and 11g, these params were no longer mentioned. Even the linkes included do not make this explicit request.
3- I ran my own testing this morning and saw the FBI being used as demo'd here. Same conclusion.
4- since the query-rewrite-enabled defaults to true now, I had no issues. However, was not sure if the integrity param needs changing and if 'enforced' is any different than 'trusted' as far as FBI is concerned. The 9i docs mentions that 'trusted' is required if index uses user-defined functions. If only sql functions are used, 'enforced' is good enough.
For all pratical purposes, this is good for what I needed. I may experiment with these settings later if I get a chance/time to do it.
Thank you all.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 03 2009 - 12:00:49 CST