MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Speed problem on large tables
Posted by: Dan Holdway
Date: October 11, 2004 03:32AM

Doh... The other table definition should have been;

CREATE TABLE `site_amazon_items` (
`Site_Amazon_Product_ID` int(11) NOT NULL auto_increment,
`Amazon_Product_ID` int(11) NOT NULL default '0',
`Site_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`Site_Amazon_Product_ID`),
UNIQUE KEY `Site_Amazon_Product_ID` (`Site_Amazon_Product_ID`),
UNIQUE KEY `Site_ID` (`Site_ID`,`Amazon_Product_ID`),
KEY `Amazon_Product_ID` (`Amazon_Product_ID`)

Options: ReplyQuote

Written By
October 11, 2004 03:19AM
Re: Speed problem on large tables
October 11, 2004 03:32AM

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.