A Z wrote:
here we go:
explain select * from properties where reference like
'%2332'
The above query cannot use the index on reference in either MyISAM or InnoDB
case. However, with MyISAM it will hurt less because you are scanning a plain
data file instead of a B-tree.
Suggestion for a workaro
-- Weitergeleitete Nachricht --
Subject: Re: Another Performance query
Date: Mon, 22 Mar 2004 16:13:29 +0100
From: Stefan Kuhn <[EMAIL PROTECTED]>
To: A Z <[EMAIL PROTECTED]>
Indices can never be used with like "%x" (but with like "x%). This
here we go:
explain select * from properties where reference like
'%2332'
+-+
Table ¦ type ¦ possible keys ¦ key ¦ key_len ¦ ref ¦
rows ¦ Extra
+-+
Properties ¦ All ¦ NULL ¦ NULL ¦ NULL ¦ NULL ¦
A Z wrote:
Thanks for your replies regarding to my previous
query.
We have encountered another problem:
MySQL 4.0.14, INNODB.
A table does have an Index on Field1, this field
(Field1) is also the Primary Key. Querying on this
field takes a long time, running along with Explain
command it displays
Thanks for your replies regarding to my previous
query.
We have encountered another problem:
MySQL 4.0.14, INNODB.
A table does have an Index on Field1, this field
(Field1) is also the Primary Key. Querying on this
field takes a long time, running along with Explain
command it displays that it d
