Re: Need Quick script for deleting calls records!

Dale E. Reed Jr. ( (no email) )
Sat, 07 Mar 1998 20:24:51 -0800

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