MySQL Forums
Forum List  »  Optimizer & Parser

Re: how to optimise query for 10+ millions records
Posted by: irek kordirko
Date: February 09, 2012 05:58PM

Sorry for my misunderstanding.

Please explain one thing - you wrote that Destination is an "outer table".
I ask because cannot find anywhere a definition of "outer table",only in MS SQL reference they mention that "outer table" is a left table for LEFT JOIN and right table for RIGHT JOIN.
Do you mean that Destination table is a left table in the LEFT OUTER JOIN ?
Or the opposite ?
If it is on the left side, and you use the condition:
IFNULL(destination.DestinationName,'Unknown') LIKE @dest
so it means that some records contain NULL in DestinationName column,
is this right ?

Options: ReplyQuote

Written By
Re: how to optimise query for 10+ millions records
February 09, 2012 05:58PM

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.