Re: URGETN - query problem

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Oct 2002 06:55:07 -0700
Message-ID: <2687bb95.0210080555.298e682d@posting.google.com>

"Arturo" <aparafiniuk_at_hdsrna.com> wrote in message news:<3da1dfe7_at_news.mhogaming.com>...
> Hi all,
>
> I'm having a problem running a query. Problem is that in test environment
> the query is optimized perfectly (I'm using CHOOSE option), it uses all
> indexes and it's quick.
>
> In production the same query doesn't use indexes at all. All indexes exist
> like in test, are valid and are on the same tables/columns. I'm using the
> same optimizer hint.
>
> I've already tried putting all indexes I want as the optimizer hint, it
> didn't help.
>
> Any ideas? Thanks in advance,
> Arturo
>
> PS: Oracle Server 7.3.4.0.1.

Arturo, you did not post an explain plan to give the group anything to work off of so: Are you sure the test version ran cost based? Do you have statistics on the test tables? Have you verified that the hint is in fact working? Did you re-analyze the production tables and indexes to see if that made any difference in the plan?

HTH -- Mark D Powell -- Received on Tue Oct 08 2002 - 08:55:07 CDT