Sujay Koduri <[EMAIL PROTECTED]> wrote on 11/15/2005 06:47:43 AM:
> hi all..
>
> i have created a table (INNODB) with a primary key column.
> And all the queries i am running are of the following type only.
>
> select col1,col2... from table where primary_key_col = value
>
> My question here i
Yes, MySQL will create an index on the field you specify as the
primary key. Instead of using "show table status", use "desc
tablename". That will show you which fields have indexes on them. The
field with the primary key index will have a PRI in the "key" column.
Indexes will always increa
hi all..
i have created a table (INNODB) with a primary key column.
And all the queries i am running are of the following type only.
select col1,col2... from table where primary_key_col = value
My question here is will mysql automatically create an index on this column
which is having the pr
