DOES ANYONE KNOW BENEFITS OF FUNTION BASED INDEX
CAN I USE INDEX WHERE
NVL(COLUMN name)= value

trunc(sysdate)=value

what will be the effect if i pass bind variable in value and hard core value in value.

Thanks
UKDBA