MySQL Lists: mysql: Re: Slow Select count(*)

List:	General Discussion	« Previous Message Next Message »
From:	Tibor Simko	Date:	February 20 2001 4:45pm
Subject:	Re: Slow Select count(*) - Second Post
View as plain text

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

Thread
• Slow Select count(*) - Second Post	Robin Keech	20 Feb
• RE: Slow Select count(*) - Second Post	Robin Keech	20 Feb
• RE: Slow Select count(*) - Second Post	Patrick FICHE	20 Feb
• RE: Slow Select count(*) - Second Post	Robin Keech	20 Feb
• *Re: Slow Select count() - Second Post**	Tibor Simko	20 Feb
• RE: Slow Select count(*) - Second Post	Robin Keech	20 Feb