Re: Advice on a weird query plan

From: Dion Cho <ukja.dion_at_gmail.com>
Date: Wed, 16 Apr 2008 21:48:57 -0700 (PDT)
Message-ID: <3277ca75-a86a-4195-ad23-3ccf76da6d9c@m3g2000hsc.googlegroups.com>


> Is there anything dbms_stats does that the old analyze table doesn't
> do? I always though it was just a convenience function, but if I'm
> missing something there, I'd like to know what I'm missing :).

Tom kyte always shows shows good answer(but Oracle manual is the most profound one all the time)

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4347359891525

> As to your suggestion, I really only have control over what happens
> below the query horizon here, so I can index all I want, move tables
> around, etc. What I can't do is modify the structure of the inbound
> queries b/c thoe are being generated by application code I don't have
> control over. If I could control that, I'd have made state an int
> instead of a varchar2 in the first place.
>
> Is there any way I could benefit from the kind of index you describe w/
> o rewriting the inbound query?

In that case, unfortunately, you might have no choice. Received on Wed Apr 16 2008 - 23:48:57 CDT

Original text of this message