How to Optimize distinct with index

Hi,
	I have a sql : 
		Select distinct user-id from user where key1=value and
key2=value2 and key3=value2;

I add index on (key1,key2,key3,user-id), this sql use temporary table
howevery
I have thousands of queries per second.
How to optimize it?


Anthoer question:
Select * from user where user-id in(id1,id2,id3,id4,.....) order by use-id;
I add index on user-id,but after in,order use temporary table, How to
optimize it?

Thanks!

zhouyanwei

Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Matt Neimeyer on 2009-06-19T01:36:47+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Johnny Withers on 2009-06-19T02:31:29+00:00
How to Optimize distinct with index by 周彦伟 on 2009-06-19T02:55:37+00:00
How to Optimize distinct with index by 周彦伟 on 2009-06-19T02:56:09+00:00
How to Optimize distinct with index by 周彦伟 on 2009-06-19T02:56:16+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Dan Nelson on 2009-06-19T07:16:37+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Matt Neimeyer on 2009-06-19T14:05:58+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Brent Baisley on 2009-06-19T15:30:39+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Peter Brawley on 2009-06-20T00:16:24+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Walter Heck - OlinData.com on 2009-06-20T02:45:38+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Matt Neimeyer on 2009-06-22T15:06:06+00:00