Quoting Manjula:
--
Thanks
Riyaj "Re-yas" Shamsudeen Certified Oracle DBA (ver 7.0 - 9i) Allocation & Assortment planning systems JCPenney
I have an application on Oracle 9i. The database (designed by the vendor) was set with optimizer_mode=CHOOSE. A week after we went live with the application, performance started degrading. I discovered that statistics were missing and built them. Immediately the application problems were resolved.
The vendor claims that with the statistics, it would not use the right indexes and some data would not be pulled up in the application. Is that possible?
Thanks,
Manjula
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.