--+
2 rows in set (0.01 sec)
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Artem Koutchine'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 5:29 PM
Subject: RE:
; To: [EMAIL PROTECTED]
> Subject: Very slow request with many ORs in where parts
>
>
> Hi!
>
> I have the following table:
>
> create table law_words (
> l_id int unsigned not null,
> w_id int unsigned not null,
> primary key (w_id, l_id)
> );
>
>
Can you post your explain plan?
-Original Message-
From: Artem Koutchine [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 8:23 AM
To: [EMAIL PROTECTED]
Subject: Very slow request with many ORs in where parts
Hi!
I have the following table:
create table law_words (
l_id
Hi!
I have the following table:
create table law_words (
l_id int unsigned not null,
w_id int unsigned not null,
primary key (w_id, l_id)
);
The request is:
SELECT DISTINCT w0.l_id FROM law_words as w0
inner join law_words as w1 on w0.l_id=w1.l_id
where w0.w_id in (258,282,... ab