do i have index on this column?

[defiance]

hi

my phpmyadmin structure for the table shows me this.

===========================
Indexes:
Keyname Type Cardinality Action Field
id UNIQUE 29720 id

===========================


this would seem like a joke, but do i have index on that table already?

if i do, indexing the ID doesnot give me much increase of performance am i right?

i need to index my field name;

thanks...

i am a total newbie in this....
cheers

[defiance]

alright.

so

i create index on my field name, like this

============================
Indexes:
Keyname Type Cardinality Action Field
id UNIQUE 29720 id
name INDEX 29720 name

============================


is that the right kind of index which i need to increase the speed?

and
when creating an index, phpmyadmin asked me for some size, but i didnt specify any size.

what is this size means?

and

i did a query before and after i made the index name.
before index the time was 0.0322 sec
and after it was
0.0301 sec

hehehe
the query returns 29 rows from 29 k rows.
is it good enough?
or is there anything else that i can do to make it faster/

thanks

[defiance]

ermm

quick question, can we remove index from phpmyadmin?
i cant seems to find the way to do it...

thanks