rray_merge() them - which
> invariably seems to solve "OR" problems. But there should be a better
> way, no?
>
> -Dave
>
> -Original Message-
> From: David Turner [mailto:[EMAIL PROTECTED]
> Sent: October 1, 2004 4:04 PM
> To: [EMAIL PROTECTED]
> Subject: I
er
way, no?
-Dave
-Original Message-
From: David Turner [mailto:[EMAIL PROTECTED]
Sent: October 1, 2004 4:04 PM
To: [EMAIL PROTECTED]
Subject: Indexing for OR clauses
Wondering if anyone can give me advice on indexing for OR clauses.
I have a table with a number of fields, two of which are
At 06:03 PM 10/1/2004, you wrote:
Wondering if anyone can give me advice on indexing for OR clauses.
I have a table with a number of fields, two of which are sender_id and
receiver_id. I also have a query such as this:
SELECT ...
WHERE (sender_id = 98765 OR reciever_id = 98765)
The query is OK
Wondering if anyone can give me advice on indexing for OR clauses.
I have a table with a number of fields, two of which are sender_id and
receiver_id. I also have a query such as this:
SELECT ...
WHERE (sender_id = 98765 OR reciever_id = 98765)
The query is OK for a limit of 10, but if I
