Re: How to optimize query's execution?

"uf" <uf_at_one.com> wrote:
> > How many rows in j have currentstate='X'?
>
> 3390
>
> > How many rows have state='postponed'?
>
> 3390
>
> How many rows have both simultaneously?
>
> 3390
>
> > What fraction of the rows in k satisfy the in-list?
>
> all of 3390

How about on the whole table, even the parts not satisfying the join to j?

>
> > What column(s) (and in what order) are included in the my_state_idx
> > index?
>
> MY_STATE_IDX ----> MY_JSTATE.INTERNAL_ID
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.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB