Posted by FFMG on 09/01/06 13:55

Given the query bellow, what keys would you create?

SELECT
t2.t1_a
FROM
table1 as t1,
table2 as t2,
table3 as t3
WHERE
t2.t2_b = t3.t3_b
AND
t2.t2_c = t3.t3_d
AND
t3.t3_e != 25
AND
t1_a = '3'
AND
t2_d ='0'
ORDER BY en.t1_a DESC
LIMIT 0, 15

Thanks

FFMG

• Next in forum: Re: phpmailer error
• Prev in forum: Re: PHP validation instead of Javascript?
• Thread view: what keys should I use on my 3 way join?

[Reply to this message]