Re: purging old data

From: Anurag Minocha <anurag_at_synergy-infotech.com>
Date: Wed, 08 Sep 1999 16:13:52 +0530
Message-ID: <37D63DE7.B04D2DC9@synergy-infotech.com>

Thanks for the help.

The problem I am having is that i have to purge data based on a query and truncate doesnt support that hence i will have to delete the records. The reason i am purging the data is because the queries will run faster if there are less number of records , but deleting wont help because oracle will go till the high water mark and then produce the result. How do i use the delete command and make my queries run faster on my tables.

Thanks
Anurag

also reply to
anurag_at_synergy-infotech.com

Mario Bucsics wrote:

> One way to do this is to disable the constraint that points
> on that table and after delete or truncate enable it.
>
> Mario Bucsics
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Wed Sep 08 1999 - 05:43:52 CDT