Posted by Arjen on 09/07/06 13:13

FFMG schreef:
> 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

Use the explain syntax

http://dev.mysql.com/doc/refman/5.0/en/explain.html

Good luck !

Arjen

• Next in forum: Re: what keys should I use on my 3 way join?
• Prev in forum: Selling my Student Rate Registration for Zend PHP Conference in San Jose
• Thread view: Re: what keys should I use on my 3 way join?

[Reply to this message]