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

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Fri, 13 May 2005 11:57:11 -0400
Message-ID: <367369f105051308577ead1153@mail.gmail.com>

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

Received on Fri May 13 2005 - 12:01:45 CDT

This message: [ Message body ]
Next message: Justin Cave (DDBC): "RE: How to use both nvl and index access without creating functional index ?"
Previous message: Christian Antognini: "RE: Extended trace analysis and perf. problem."
Next in thread: Justin Cave (DDBC): "RE: How to use both nvl and index access without creating functional index ?"
Maybe reply: Justin Cave (DDBC): "RE: How to use both nvl and index access without creating functional index ?"
Maybe reply: Daniel Wittry: "RE: How to use both nvl and index access without creating functional index ?"
Reply: Tim Gorman: "Re: How to use both nvl and index access without creating functional index ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US