RE: Query works fine in 8i and not in 9i

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Wed, 11 Aug 2004 12:19:09 -0400
Message-ID: <1357B9FD14F9D41187800008C7A47B350336A5F8@corpa1.polaroid.com>

Abraham,
What method are you using to assign statistics? We had a similar problem and resolved it by switching from "ESTIMATE N PERCENT" to "COMPUTE STATISTICS". Mike Hand
Polaroid Corp

---

Hello list members,

I have a query that runs fast in SUN 8i and terrible in HP 9i.=20

--

This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Aug 11 2004 - 11:16:17 CDT