Re: Is this a candidate for a stored outline?

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 03 May 2003 06:50:19 -0700
Message-ID: <vOPsa.2716$MJ5.77@fed1read03>

Ryan wrote:
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
> news:eGEsa.921$MJ5.118_at_fed1read03...
>

>>Ryan wrote:
>>
>>>hmmm... I have 2 table sthat Im joining regularly based on different

>
> where
>

>>>clauses. Is it ever a good idea to run a cursor to just get those two

>
> tables
>

>>>blocks into memory?
>>
>>It depends.
>>
>>What part of "Enable SQL TRACE to get facts rather than draw conclusions
>>based upon idle speculation." did you NOT understand?
>>
>>
>>

>
>
> i dont have any experience analyzing sql trace.
>
>

Maybe it is now time to learn a new tool. Of course you can simply keep taking pot shots in random directions. It is your choice & only you suffer/enjoy the consequences.

HAND! Received on Sat May 03 2003 - 08:50:19 CDT