I agree that the optimizer was never something that we were told that we had any configuration control over. I believe that the DBMS is not only the logical place for such an object, but is where it's always been.

I couldn't find any reference to it in the Remedy .pdf docs, but I did find it mentioned in the PT&T book (4.x - Module 6) several times. Only one of those even hinted that it might be a DBMS tool. The rest didn't specify its source.

SO: In conclusion of this thread (hopefully), Query Optimizers exist in the DBMS, but the PT&T class wasn't all that clear on that aspect of them. I'm satisfied now. Thanks for your patience with me, all.

Rick

-----Original Message-----
From: Shellman, David [mailto:dave.shellman@TYCOELECTRONICS.COM]
Sent: Friday, February 07, 2003 2:07 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: ARS Performance/Responsiveness


Rick,

The performance tuning class that I took a several years ago referred to
the "Optimizer" in the generic terms as Doug mentioned. The class offered
suggestions on tweaks to the different Optimizers based on the DBMS being
used. All of these tweaks were done at the DBMS level. They are not done
through the AR System.

Dave

>Date: Fri, 7 Feb 2003 11:00:18 -0800
>From: Rick Cook
>Subject: Re: ARS Performance/Responsiveness
>
>I'm not upset - just trying to find the answers to resolve this issue, =
>and confused that there is some inconsistency in what I am hearing vs. =
>what I know. I can easily count on one hand the number of people on =
>this list who have ever offended me, and you aren't one of them, Nicky, =
>so don't worry. :)
>
>I'm not saying that Doug or the docs are wrong - just that there appears =
>to be a misunderstanding of the term "Remedy Query Optimizer", and its =
>role in doing (or not doing) what the name implies. I look forward to =
>all of us (including me) having our knowledge completed in this area.
>
>Rick


Dave Shellman

Phone: (717)810-3687
Fax: (717)810-2124
email: dave.shellman@tycoelectronics.com

tyco ELECTRONICS GROUP
A tyco INTERNATIONAL LTD COMPANY
MS 161-043
PO Box 3608
Harrisburg, PA 17105-3607