Function based index not being used

I am trying to create a function based index to speed up a query, but the index doesn't seem to be used. The user defined function is based on a java stored procedure, I'm not sure if that could be the problem? Also, the function is not owned by the user creating the index, but the function is executable by public.

Any ideas why the index is not used? Thanks.

• Recreate the function as deterministic so it can be used in a function based index.

CREATE OR REPLACE FUNCTION myFunction(inData VARCHAR2, ...) RETURN RAW
DETERMINISTIC
AS
LANGUAGE java
NAME 'com....myFunction (java.lang.String ...) return byte[]'; /

• Create table with sample data create table indxtest as select * from all_objects where rownum <= 1000;
• Create function-based index create index indxtest_func_idx2 on indxtest(otherUser.myFunction(object_name, ...));
• try to select using the function based index select * from indxtest where otherUser.myFunction(object_name, ...) = 'aaa';

no rows selected

Execution Plan

   0 SELECT STATEMENT Optimizer=CHOOSE    1 0 TABLE ACCESS (FULL) OF 'INDXTEST' Received on Wed Jul 06 2005 - 19:38:07 CDT