RE: How to use both nvl and index access without creating functional index ?
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <ranko.mosic@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 May 2005 10:11:53 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ranko Mosic
Sent: Friday, May 13, 2005 11:57 AM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
