URGENT - query problem
From: Arturo <aparafiniuk_at_hdsrna.com>
Date: Mon, 7 Oct 2002 16:09:35 -0400
Message-ID: <3da1eaaf$1_at_news.mhogaming.com>
[Quoted] Hi all,
Date: Mon, 7 Oct 2002 16:09:35 -0400
Message-ID: <3da1eaaf$1_at_news.mhogaming.com>
[Quoted] 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. Received on Mon Oct 07 2002 - 22:09:35 CEST