Bind variables and function based index

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Tue, 6 May 2008 16:54:31 -0700
Message-ID: <a2b1e7610805061654l57246812o68ff3826fbaeef2a@mail.gmail.com>

Hi
Is there any restriction with bind variables and function based indexes. I noticed that if I have literals fbi is being used but if I replace that with bind variables then fbi is not used. DB version is 10.2.0.1. You cant seem to force it to use FBI through hints also. As I am investigating this, I thought of posting here to see if there are any known issues or restrictions that prevent function based indexes usage with bind variables. QUERY_REWRITE_INTEGRITY is set to trusted and query_rewrite_enabled is true.

thank you
- kumar

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 06 2008 - 18:54:31 CDT

This message: [ Message body ]
Next message: Mark W. Farnham: "RE: Sizing rollback segments"
Previous message: fairlie rego: "Patches for Dataguard on top of 10.2.0.3"
Next in thread: Kumar Madduri: "Re: Bind variables and function based index"
Maybe reply: Kumar Madduri: "Re: Bind variables and function based index"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message