Re: Why Dropping Tables are Slow?

From: gremlin <gremlinNO__SPAM___at_ix.netcom.com>
Date: Wed, 17 Mar 1999 01:28:27 -0500
Message-ID: <36EF4B8B.630E66AC@ix.netcom.com>

Hi:

As for the "why", I don't know. I had a similar problem and generally use truncate now. Give it a shot.

Mike

Julia Cristina Varela de Montoya wrote:

> When I run a script to drop many tables and even views, it takes a very long
> time using the Cost optimizer - up to 90 seconds each! However when we
> switch to Rule mode, it speeds up to a "normal" amount of time. Does
> someone can tell me why the difference? We have analyzed the tables, but we
> did not create any histograms. We only write scripts to "analyze table xxx
> compute statistics".
>
> We use version 7.3.4.
>
> Thank you very much.

--

---

To reply to me via email, remove the "__NO_SPAM__" in the header email address.

---

Received on Wed Mar 17 1999 - 00:28:27 CST