I have a table with 12 million records. If I try DROP TABLE it takes
forever. I tried TRUNCATE TABLE and that takes a long time too. Is
there any way to delete the entire table quickly?
- WAS CANCELLED BY =======:
From: miker <mdent12_at_none.com>
Control: cancel <p0t35ucv12snrajjelbaj0oa0qg3dnu58d_at_4ax.com>
Subject: cmsg cancel <p0t35ucv12snrajjelbaj0oa0qg3dnu58d_at_4ax.com>
Date: Mon, 28 Jan 2002 02:19:54 GMT
Message-ID: <cancel.p0t35ucv12snrajjelbaj0oa0qg3dnu58d_at_4ax.com>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news.tele.dk!small.news.tele.dk!204.71.34.15!news-out.cwix.com!newsfeed.cwix.com!cpk-news-hub1.bbnplanet.com!news.gtei.net!news.voicenet.com!feedeast.news.agis.net!aleron.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40721546
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.
Received on Fri Jan 25 2002 - 18:12:28 CST