MySQL Forums
Forum List  »  InnoDB

Does table always have the primary key?
Posted by: Eddy Setiawan
Date: November 26, 2008 06:38AM

Does table always have the primary key? Is the primary key effect for performance of the table?

I have 4000 rows in two tables (example table store and table dstore)
I use query like this "SELECT * FROM STORE S, DSTORE D WHERE D.KODE=S.KODE"
The data is slow when I use that query. Is that effect for not use primary key?

Options: ReplyQuote


Subject
Views
Written By
Posted
Does table always have the primary key?
2062
November 26, 2008 06:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.