MySQL Forums
Forum List  »  Optimizer & Parser

Re: how to optimise query for 10+ millions records
Posted by: irek kordirko
Date: February 13, 2012 02:18PM

Hi Azhar,

Questions are:
- are tables out_route and in_route indexed by 'value' column ?
- is there a constraint "NOT NULL" on the 'value' column in these tables ?
If no, then change the structure of these tables:
alter IGNORE table out_route add constraint PRIMARY KEY ( value ) ;
alter IGNORE table in_route add constraint PRIMARY KEY ( value ) ;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to optimise query for 10+ millions records
1362
February 13, 2012 02:18PM


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.