Re: Need Quick script for deleting calls records!

Kelly Wright ( (no email) )
Sun, 15 Mar 1998 11:55:34 -0600

Dale can you expand on how you do this. Right now our database is showing
100Megs big. With 300 MR we should not have log problems but we are..

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
Date: Saturday, March 07, 1998 10:31 PM
Subject: Re: Need Quick script for deleting calls records!

>Tom Bilan wrote:
>>
>> delete from calls where acctstatustype = 1
>
>As a side note, if you are doing this often (I have SQL Executive
>do it every night), you should put an index on the acctstatustype
>field in the calls table. It will greatly improve the speed. :)
>
>--
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>