|Subject||Re: [ib-support] Query Plan|
On Saturday 24 February 2001 10:45, you wrote:
> At 06:46 PM 2/23/2001 -0700, Jason Wharton wrote:Its Joe Celko assuming you mean the author of "SQL For Smarties".
> > > Thank you very much for the trick about adding || to
> > > avoid indexes. It really helps me out. I really like
> > > it instead of specifying plan manually.
> >You are welcome, it surprises me how often I have relied upon this. I
> > can't remember exactly who I learned this from but it is one of my little
> > gems.
> For what it's worth, Joe Clecko (sp?) mentions it in his book
> and I remember a discussion involving Geoff McInnes about the
> applicability of the technique to InterBase.