Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Execution Plan

Re: SQL Execution Plan

From: Tom Hester <thester_at_metadata.com>
Date: Tue, 16 Nov 2004 11:03:50 -0800
Message-ID: <eaaa8$419a4eab$45033832$26121@msgid.meganewsservers.com> 





A couple of days is a long time not to update stats on a dynamic 
database.  Just guessing, but I would bet that each new day invalidates 
the use of an index on a date field for the optimiser.



Steve J wrote:


> The stats are a couple of days old.  When we look at the plan for the

> following query it does a full table scan:

> Any thoughts?

> 

> Thanks...

Received on Tue Nov 16 2004 - 13:03:50 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US