On Wed, 21 Aug 2002, Brian Moon wrote:
> If I have a query like:
> select field1 from table where field2=0 order by field3 desc limit 30;
> and I have keys:
> key field2 (field2)
> key field3 (field3)
>
> Will MySQL use one key to select and one to order? Or do I need a:
>
> key field2_field3 (
try select * from table where field2=0 order by field3 desc limit 30
I think you need the column to compare.
> If I have a query like:
>
> select field1 from table where field2=0 order by field3 desc limit 30;
>
> and I have keys:
>
> key field2 (field2)
> key field3 (field3)
>
> Will MySQL u
If I have a query like:
select field1 from table where field2=0 order by field3 desc limit 30;
and I have keys:
key field2 (field2)
key field3 (field3)
Will MySQL use one key to select and one to order? Or do I need a:
key field2_field3 (field2, field3)
This is a big table and i don't want
