Re: How to optimize query's execution?

From: uf <uf_at_one.com>
Date: Thu, 1 Sep 2005 12:06:30 +0200
Message-ID: <df6jra$2ku$1@domitilla.aioe.org>

> Are you sure? I can't understand why oracle would be doing a range
> scan on this index (as the driver of a nested loop) if that is all it
> contains. Anyway, is there another index which is on currentstate or
> state? If not, there probably should be.
>

select distinct state from my_jstate;

STATE

---

postponed

select distinct currentstate from my_jstate;

C
-
X

Hm, there is existing index on state, but not on current state. I will try to create index and see what will happen. Received on Thu Sep 01 2005 - 05:06:30 CDT