Re: how to optimise query for 10+ millions records

[irek kordirko]

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 ) ;