From: Martijn Tonies
Date: November 24 2003 4:00pm
Subject: Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB  SELECT speed)
List-Archive: http://lists.mysql.com/mysql/154393
Message-Id: <041c01c3b2a4$0ebc7bc0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-2"
Content-Transfer-Encoding: 7bit

Hi,


> You are not using any indicies, because there aren't any that could be
> used in this query.
> Try adding an index on (status,deleted)

I wonder: how many possible different values would such an index
return? If this is a (very) low value, won't the index make things
slower (if it's being used) compared to a full table scan?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com