List:General Discussion« Previous MessageNext 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 columnsBalazs Rauznitz20 Jan
  • Re: Select on indexed columnsAleksandar Bradaric20 Jan
    • Re: Select on indexed columnsBalazs Rauznitz20 Jan
      • Re[2]: Select on indexed columnsAleksandar Bradaric20 Jan
        • Re: Select on indexed columnsBalazs Rauznitz20 Jan
          • Re: Select on indexed columnsDan Nelson20 Jan
  • Re: Select on indexed columnsolinux21 Jan