Hello David,
On 25/05/2016 15:29, David G. Johnston wrote:
Thank you a lot for your thorough explanation, the above might be the best solution.
I understand, but still this does not look conceptually right.
So I guess we must introduce an optimization fence by the means of a CTE or the use OFFSET. Since we must replicate this query on a 8.3 (well 100s of them actually) as well, I guess OFFSET is the way to go.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt