FYI - that tip on my site applies to v9 and maybe even earlier versions... hth connor On 5/14/05, Justin Cave (DDBC) <jcave@xxxxxxxxxxx> 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@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- //www.freelists.org/webpage/oracle-l