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

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Sun, 15 May 2005 17:05:40 +0800
Message-ID: <5e30486205051502054f8e071e@mail.gmail.com>

FYI - that tip on my site applies to v9 and maybe even earlier versions...

hth
connor

On 5/14/05, Justin Cave (DDBC) <jcave_at_ddbcinc.com> wrote:
> Are you using 10g? It appears that Oracle changed the way it handles
> NVL in 10g so that regular indexes can now be used

>=20

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

>=20

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

>=20

--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

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

Received on Sun May 15 2005 - 05:10:16 CDT