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 primary key constraint. (This is what i am asusming all
the time, as oracle do this)
But when i do a show table status on this table, it is giving the index
length as 0. (does this mean there is no index on this column ?)
And if i create an index now on this primary key column, is it going to
increase my performance anyway.
I am using mysql 4.1.14 on RHEL 3.0
Thank you
sujay
