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: How to remove specific function calls from source code...
• Prev in forum: Re: SOLVED: How to upload form data containing special characters correctly?
• Thread view: Re: what keys should I use on my 3 way join?

[Reply to this message]