Re: Analyzing tables

From: Ronald Rood <devnull_at_ronr.nl>
Date: 27 Apr 2004 06:21:21 -0700
Message-ID: <67ce88e7.0404270521.277d9c23@posting.google.com>

kramesh_india_at_yahoo.com (ramesh) wrote in message news:<a633cb92.0404262219.79b24fd3_at_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.

What command did you exactly run, on what version and on what platform ? I don't suppose it's on 7.1 but there are a few different choices here.

Regards,
Ronald

http://ronr.nl/unix-dba Received on Tue Apr 27 2004 - 08:21:21 CDT