noudshoorn wrote:
> In this part the table has an autoincrmentfiled. This field has to be a primary key with the name
> primary??? An index on name or departuredate is not used!?
Like I said in a previous post - I don't think you can make sensible comments when you have such a small number of rows.
> Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part
> Packed Null Index_type Comment
> A 0 PRIMARY 1 admin A 8 NULL NULL BTREE
> A 1 name 1 name A 2 NULL NULL BTREE
> A 1 name 2 departuredate A 8 NULL NULL BTREE
> A 1 name 3 departuretime A 8 NULL NULL BTREE
> A 1 departuredate 1 departuredate A 4 NULL NULL BTREE
> A 1 departuredate 2 departuretime A 8 NULL NULL BTREE
I don't think it's very useful to have both (name, departuredate, departuretime) and (departuredate, departuretime) as indexes, and why don't you use a DATETIME column?
--
felix
Please use
BBCode to format your messages in this forum.