Re: Outer Join Performance

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: Mon, 29 Mar 1999 06:16:16 GMT
Message-ID: <QUEL2.10874$mi3.3045@nnrp3.clara.net>

keith boulton wrote in message <36fcfbd6.20690471_at_195.147.246.90>...
>On 27 Mar 1999 14:59:01 GMT, "Julia Cristina Varela de Montoya"
><jc_va_at_hotmail.com> wrote:
>
>>Thank you! I visited your web page and your article is very relevant to
>>that problem. In fact, I am going to use your suggeston and use Oracle
>>functions to remove some joins, which should speed thins up considerable.
>>
>
>If by oracle functions you mean user written PL/SQL functions in a
>query/select statement, you should be aware that these bypass
>statement level read consistency.

Agreed. But in the majority of cases, I believe that this effect will have minimal impact on the design considerations for the query and can be tolerated in most applications. Although it is fair to warn people of this. I have updated my paper accordingly.

Dave.
--
Remove "nospam" from my address to reply by email Received on Mon Mar 29 1999 - 00:16:16 CST