Re: What index do I need for this query ?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 26 Mar 2009 09:49:06 +0000 (UTC)
Message-ID: <gqfj2h$u3a$2_at_solani.org>
On Tue, 24 Mar 2009 17:12:27 -0700, Mark D Powell wrote:
Date: Thu, 26 Mar 2009 09:49:06 +0000 (UTC)
Message-ID: <gqfj2h$u3a$2_at_solani.org>
On Tue, 24 Mar 2009 17:12:27 -0700, Mark D Powell wrote:
> Also shouldn't "AND NVL(INVH.TAXNO,' ')<>' " be " and invh.taxno is
> not null " ?
Or, slightly better when talking about indexes, invh.taxno > 0
Do you know any place in the world with negative tax numbers? China and India may soon run out of 32 bit tax numbers, but negative ones would be very, very strange.
-- http://mgogala.freehostia.comReceived on Thu Mar 26 2009 - 04:49:06 CDT