Hi,=20 I have to use NVL function ( or similar ) in where clause.=20 I need to have column accessed via index.=20 Creation of functional indexes on nvl(column_name ) can not be done for all columns ( political and other reasons ).=20 Is there a way ?=20 Regards, Ranko. -- //www.freelists.org/webpage/oracle-l