denormalize using function based indexes

Can function based indexes be used to implement denormalization?

i have tables
  tab1 (att1 varchar2(100), att2 varchar2(200)

        att3 varchar2(200), value number);   tab2 (value number , val2 number);

 select tab2.val2 from tab1, tab2
  where tab1.att1 = my_var1
    and tab1.att2 = my_var2
    and tab1.att3 = my_var3
    and tab1.value = tab2.value;

Is there any way to bend function-based
indexes in a way that gets rid of the join?

I cannot denormalize the app I'm working on by adding tables but indexes are fair game. Ideas, speculations, and example code appreciated,

--
thanks for reading


Sent via Deja.com http://www.deja.com/
Before you buy.