Re: how to optimise query for 10+ millions records
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 ?
Subject
Views
Written By
Posted
3063
February 09, 2012 03:30AM
1751
February 09, 2012 05:31AM
1419
February 09, 2012 05:38AM
Re: how to optimise query for 10+ millions records
1321
February 09, 2012 05:58PM
1296
February 11, 2012 11:26PM
1554
February 12, 2012 10:12PM
1407
February 13, 2012 02:18PM
1625
February 14, 2012 02:33AM
1427
February 14, 2012 07:24AM
1434
February 15, 2012 07:30AM
1879
February 16, 2012 03:54AM
1317
February 17, 2012 01:20AM
1271
February 17, 2012 03:57PM
1565
February 17, 2012 05:12PM
1358
February 18, 2012 07:18AM
1416
February 21, 2012 03:25AM
1423
February 24, 2012 10:45AM
1361
February 20, 2012 02:21AM
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.