optimizer time reported as?

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: 2006-01-11 22:00:53
Message-id: B39B7B7D8C8CEA419D0ED45FD7FA4C53EDD3FD@CWYMSX06.Corp.Acxiom.net

I got asked about performance on a database that was recently upgraded from 8.1.7.4 to 9.2.0.6.

Looking at the initora I noticed
optimizer_max_permutations integer 79999

The DBA doing the upgrade said she only changed the parmaeters relating to the upgrade.
I know the default changed from 8's 80000 to 9's 2000 and there was an earlier TAR telling us to change the
80000 to 79999.

I thought this might be an issue and I ran Tim Gorman's sp_time script to see where the overhead was.
I just wanted to verify that the optimizer_max_permutations time is accounted for in the
Parsing SQL time and not somewhere else.

TIA
Larry Wolfson

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.

Received on Wed Jan 11 2006 - 22:00:53 CST