As I know prepare a drop rollback-information (like delete from ) although
you cannot rollback the command. Therefore truncate table first (emptying
table without creating rollback information). After then drop it.
Julia Cristina Varela de Montoya schrieb in Nachricht
<7cn49r$hul_at_bgtnsc02.worldnet.att.net>...
>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.
>
>
Received on Wed Mar 17 1999 - 08:30:36 CST
