Re: dbms_stats default

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 20 Dec 2002 09:29:23 -0800
Message-ID: <3E035373.FA2B0663@exesolutions.com>

John Darrah wrote:

> I was looking at the dbms_stats package and noticed that the
> gather_table_stats procedure defaults to gathering statistics for all
> columns on a table. It seems to me that the only columns I would want to
> gather stats on would be those that are indexed. Does anybody know if the
> optimizer can do anything with stats on non indexed columns? It can't effect
> join order but does it affect how predicates in the where clause are
> applied? Any help would be appreciated.
>
> Thanks
>
> John

Do you only use indexed columns in your WHERE clauses?

Daniel Morgan Received on Fri Dec 20 2002 - 11:29:23 CST