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

Are you using 10g? It appears that Oracle changed the way it handles NVL in 10g so that regular indexes can now be used

http://www.oracledba.co.uk/tips/nvl_smarts.htm

If you are on an earlier version of Oracle, your only option would be function-based indexes.

Justin Cave =20
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ranko Mosic Sent: Friday, May 13, 2005 11:57 AM
To: oracle-l_at_freelists.org
Subject: How to use both nvl and index access without creating functional index ?

Hi,=3D20
I have to use NVL function ( or similar ) in where clause.=3D20 I need to have column accessed via index.=3D20 Creation of functional indexes on nvl(column_name ) can not be done for all columns
( political and other reasons ).=3D20

Is there a way ?=3D20

Regards, Ranko.
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri May 13 2005 - 12:11:24 CDT