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

Home -> Community -> Usenet -> c.d.o.misc -> Analyzing tables

Analyzing tables

From: ramesh <kramesh_india_at_yahoo.com>
Date: 26 Apr 2004 23:19:07 -0700
Message-ID: <a633cb92.0404262219.79b24fd3@posting.google.com> 






Hi All,


         I was running Analyze command on a large table (Oracle
database) thinking that it would help in query performance. But it was
taking long


time and so I "Stopped" the command in the middle. Now I see that
the query which was working reasonably fast on the table is taking
"very" large amount of time. Any pointers to this.



Thanks in advance,


Ramesh
Received on Tue Apr 27 2004 - 01:19:07 CDT












Original text of this message













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