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: After table analyzed query runs 8 hours longer

Re: After table analyzed query runs 8 hours longer

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 20 Sep 2004 12:34:50 -0700
Message-ID: <3722db.0409201134.42587289@posting.google.com> 





From what I see, your slow-running query accesses multiple tables, but
you say that you calculated stats for ONE table. Be consistent and
analyze the stats for ALL the tables involved. Please post at least
the query.



Daniel
Received on Mon Sep 20 2004 - 14:34:50 CDT












Original text of this message













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