Re: Dynamic SQL Vs Static SQL using Pro*C..

I have not seen the original post. But, generally speaking, static SQL is pro-performance since the optimizer stores and reuses the optimized query execution plan. Thus, resulting in faster response time for repeated queries. CBO is the way to go, forget RBO.

Nabil Courdy
moab_at_emirates.net.ae

michael twaddell TWA <175501_at_dallas.dseg.ti.com> wrote in message <35656668.2781E494_at_dallas.dseg.ti.com>...
>Thomas Kyte wrote:
>>
>> So dynamic sql does not decrease performance but not using bind variables
 will
>> (in general). There are cases when you don't want to use bind variables
 (data
>> warehouses that rely heavily on the CBO come to mind) but for most
 applications
>> bind variables are the way to go...
>
>Thomas,
>Could you expand on this for me? I thought that we should always use
>bind
>variables. What is it about Data Warehouse and the Cost Based Optimizer
>that
>make this different? Admittedly, I don't work much with Data Warehouse
>applications at the present, but this intrigued me. I've also looked in
>the
>Administrator's and Application Developer's guides, but cannot find a
>reference
>to this. I really appreciate your input to this newsgroup and would be
>grateful
>for any information you can provide. Thanks in advance.
>
>--
>Michael Twaddell
>Raytheon Systems
>twaddell_at_ti.com
Received on Sat May 23 1998 - 00:00:00 CDT