How to use both nvl and index access without creating functional index ?

From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 13 May 2005 11:57:11 -0400

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.
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: How to use both nvl and index access without creating functional index ?
From: Tim Gorman

Other related posts:

» How to use both nvl and index access without creating functional index ?
» RE: How to use both nvl and index access without creating functional index ?
» RE: How to use both nvl and index access without creating functional index ?
» Re: How to use both nvl and index access without creating functional index ?
» Re: How to use both nvl and index access without creating functional index ?
» Re: How to use both nvl and index access without creating functional index ?

Browse oracle-l