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 ¦ NULL ¦
2923 ¦ Using Where
describe properties;
+-----------------------------------------------------+
Field ¦ Type ¦ Null ¦ Key ¦ Default ¦ Extra
+-----------------------------------------------------+
Reference ¦ VarChar(7) ¦ ¦ PRI ¦ ¦
show index from properties;
+-----------------------------------------------------+
Table ¦ Non_unique ¦ Key_name ¦ Seq_in_index ¦
Column_name ¦ Collation ¦ Cardinality ¦ Sub_part ¦
Pakced ¦ Null ¦ Index_type ¦ Comment
+-----------------------------------------------------+
properties ¦ 0 ¦ PRIMARY ¦ 1 ¦ Reference ¦ A ¦ 2923 ¦
NULL ¦ NULL ¦ ¦ BTREE
regards
--- Benoit St-Jean <[EMAIL PROTECTED]> wrote: > 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 that it does not use the index.
>
> >Prior converting to INNODB it had been working fine
> in
> >MYISAM.
> >
> >What could cause this problem?
> >
>
> Can you provide us with the EXPLAIN of the query, a
> DESCRIBE TABLE and a
> SHOW INDEX to help us pinpoint what the problem is?
>
___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
