At 01:55 15/01/99 +0200, [EMAIL PROTECTED] wrote:
>>>>>> "Pete" == Pete Harlan <[EMAIL PROTECTED]> writes:
>
>Pete> Hi,
>Pete> So you're saying that there's no solution, no combination of indexes
>Pete> that can help with 'where a=b or c=d'?
>
>Not with MySQL (and not with any other SQL server I have tried, even
>if I am sure that some of the bigger one MUST have something for this)
Unless of course you caclulate the value of (a=b or c=d) on INSERT /
UPDATE, and store that value in an indexed field.
Aren't UNIONs on the wish list?
Colin
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
