MySQL Lists: mysql: Re[2]: Select on indexed columns

List:	General Discussion	« Previous Message Next Message »
From:	Aleksandar Bradaric	Date:	January 20 2004 7:23pm
Subject:	Re[2]: Select on indexed columns
View as plain text

Hi,

>> > Any way to make this faster ?
>> 
>> Try to create an index on both fields:
>> 
>>   create index idsex_index on sex (id, sex)

> Tried that; same results...

Could  you  post  the  result of the EXPLAIN command on that
query?


Take care,
Aleksandar

Thread
• Select on indexed columns	Balazs Rauznitz	20 Jan
• Re: Select on indexed columns	Aleksandar Bradaric	20 Jan
• Re: Select on indexed columns	Balazs Rauznitz	20 Jan
• Re[2]: Select on indexed columns	Aleksandar Bradaric	20 Jan
• Re: Select on indexed columns	Balazs Rauznitz	20 Jan
• Re: Select on indexed columns	Dan Nelson	20 Jan
• Re: Select on indexed columns	olinux	21 Jan