Optimizer issue

From: Manjula Krishnan <oradba.la_at_gmail.com>
Date: Fri, 19 May 2006 10:05:05 -0500
Message-ID: <9c92486f0605190805y58c741d6s6484a2534732c9fa@mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 19 2006 - 10:05:05 CDT