Re: What index do I need for this query ?
Date: Thu, 26 Mar 2009 09:49:06 +0000 (UTC)
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.Received on Thu Mar 26 2009 - 04:49:06 CDT