Re: Trouble with multi-table query

From: Ed Prochak <edprochak_at_magicinterface.com>
Date: Sat, 10 Nov 2001 04:02:43 GMT
Message-ID: <3BECD1F9.AE668278@magicinterface.com>

Alan wrote:
>
> LIKEs are going to kill you, as it precludes the use of an index on that
> column. The outer joins aren't helping you any, either.
>

a LIKE clause of itself will not preclude use of an index. The pattern used forces the optimizer to choose one way or the other.

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com

Received on Fri Nov 09 2001 - 22:02:43 CST