Re: What index do I need for this query ?
From: ddf <oratune_at_msn.com>
Date: Fri, 3 Apr 2009 11:51:55 -0700 (PDT)
Message-ID: <ea275942-4a60-4eab-b55e-48264b040d68_at_r18g2000vbi.googlegroups.com>
On Mar 26, 4:49 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> 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.com
Date: Fri, 3 Apr 2009 11:51:55 -0700 (PDT)
Message-ID: <ea275942-4a60-4eab-b55e-48264b040d68_at_r18g2000vbi.googlegroups.com>
On Mar 26, 4:49 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> 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.com
Not if you live on Htrae and use Elcaro to create your Esabatads. Of course all Elbats would use reverse-key Xednis ...
<g>
David Fitzjarrell Received on Fri Apr 03 2009 - 13:51:55 CDT