Bjarke Wedemeijer wrote:
> "Billy" <vslabs_at_onwe.co.za> wrote in message news:<1116999853.585303.108350_at_o13g2000cwo.googlegroups.com>...
>
>>Bjarke Wedemeijer wrote:
>>
>>
>>>If the cause is different access paths, I afterwards run a 10053 in
>>>the same way. 10046 let you know, without guessing what is going on.
>>
>>Good.. but that course is only taught after Basic Troubleshooting 101
>>and requires DBA access or public trace files ;-)
>
>
> Hi Billy
>
> for 10053 interpretation look at
> http://www.centrexcc.com/SQL%20Tuning%20with%20Statistics.pdf
> Its breitlings paper.
>
> I understand your security issue wrt. DBA access and public trace files,
> therefore I said that you might reproduce the problem on a test system
> with these rights.
Thank you ... great link.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu May 26 2005 - 00:40:30 CDT
