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

  • From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 15 May 2005 17:05:40 +0800

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


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
> If you are on an earlier version of Oracle, your only option would be
> function-based indexes.

Connor McDonald
email: connor_mcdonald@xxxxxxxxx

"Semper in excremento, sole profundum qui variat"

Other related posts: