Re: Advice on a weird query plan

From: Dion Cho <>
Date: Wed, 16 Apr 2008 21:48:57 -0700 (PDT)
Message-ID: <>

> 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)

> 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