Re: SQL *Plus

From: <markp7832_at_my-deja.com>
Date: Thu, 06 Apr 2000 16:39:07 GMT
Message-ID: <8ciej8$4bs$1@nnrp1.deja.com>

In article <Ff2H4.713$tk.1756_at_news1.mco>, "Jerry" <jpsowell_at_bellsouth.net> wrote:
> What would casuse an SQL script to run very slowly with
> SQL *Plus. Ran this script before and it ran fine, now it is
> taking five or six times longer. Could environment variables
> have changed.
>
>

Has the amount of data in the underlying table changed? Were any changes made to the table or assiciated index structures?

Try explaining the query, then update the statistics on the tables involved in the query, and re-explain the query again to see if the optimizer changed it's plan due to the statistics updte. Rerun your query to check the performance.

If you still have a problem and need assistance you will need to post the query, plan, and index structures to get inteligent help. --
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 06 2000 - 11:39:07 CDT