MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: Creating Index for Many to Many Junction Table
Posted by: Raphael Thomas
Date: February 22, 2008 03:38PM

For anyone wondering, I dropped the primary key index on the `catalog_product_keyword` table and just used foreign key references and the query is being returned at a normal speed (80ms).

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Creating Index for Many to Many Junction Table
Raphael Thomas
February 21, 2008 04:05PM
Re: Creating Index for Many to Many Junction Table
Raphael Thomas
February 22, 2008 03:38PM
Re: Creating Index for Many to Many Junction Table
Michael C. Harris
March 01, 2008 11:31PM


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.