Re: index not hit ?

2002-05-31 Thread Egor Egorov
kmlau, Friday, May 31, 2002, 1:18:26 PM, you wrote: k> show index from gwarp; k> mysql> k> +---+++--+-+---+ k> -+--++-+ k> -> | Table | Non_unique | Key_name | Seq_in_index | Column_name | k> Co

index not hit ?

2002-05-31 Thread kmlau
show index from gwarp; mysql> +---+++--+-+---+ -+--++-+ -> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | -> +---+

index not hit?

2002-03-06 Thread Egor Egorov
Stephan, Wednesday, March 06, 2002, 1:24:37 PM, you wrote: SB> We are running a mysql database version 3.22.32. SB> I have an simple table: SB> id, int(10) unsigned, PRI, default 0, auto_increment SB> usernummer, int(10) unsigned, default 0 SB> productcode, char(10), default '' SB> monat, tinyin

index not hit?

2002-03-06 Thread Stephan Bulheller
Hello, We are running a mysql database version 3.22.32. I have an simple table: id, int(10) unsigned, PRI, default 0, auto_increment usernummer, int(10) unsigned, default 0 productcode, char(10), default '' monat, tinyint(3) unsigned, default 0 jahr, mediumint(8) unsigned, MUL, 0 and two indize