Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: is Null or = null and a slow query

Re: is Null or = null and a slow query

From: <willy_gates_at_hotmail.com>
Date: 4 Nov 2005 08:09:11 -0800
Message-ID: <1131120551.077847.20910@g43g2000cwa.googlegroups.com>

Yes this seems to speed things up a bit.

Follow up questions:

1> Why?
2> What about if my columns could contain null values? Received on Fri Nov 04 2005 - 10:09:11 CST

This message: [ Message body ]
Next message: Noel: "Re: Cancelling a long running query"
Previous message: Niall Litchfield: "Re: Oracle does not use an index"
In reply to: Ben Graham: "Re: is Null or = null and a slow query"
Next in thread: Jack Addington: "Re: is Null or = null and a slow query"
Reply: Jack Addington: "Re: is Null or = null and a slow query"

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