RE: Slow Select count(*) - Second Post

[Robin Keech]

Thanks for all your help.

This has got the query time down to 5 seconds from 2 minutes!!

Much appreciated everyone.

Robin

-----Original Message-----
From: Tibor Simko [mailto:tibor.simko@stripped]
Sent: 20 February 2001 16:46
To: Robin Keech
Cc: 'mysql@stripped'
Subject: Re: Slow Select count(*) - Second Post


Hello

> Is there any way to re-write SQL to force the optimiser to use a certain
> index?

SELECT foo FROM bar USE INDEX baz WHERE ...

See the manual at <http://www.mysql.com/doc/J/O/JOIN.html>.

cheers
-- 
TS