Delete Query

  • Thread starter Thread starter Sean Nijenhuis
  • Start date Start date
S

Sean Nijenhuis

Hi, thanks for your time.

I'm running a delete query on a table with about 300000 records in it. The
database size before the query is run is 36megs.

On running the query the database grows to 1.7Gb.

Please can someone shed some light on this and is there a way of deleting
records without increasing the size of the database?

Thanks
Sean
 
You should Compact and Repair your database to reclaim the space consumed by
your data and application objects even after deleting.

Regards,

Sal Rosario
Database Cosultant in NJ
www.salrosario.com
 
Thanks for the reply.

Understood, but its in running this query that in some instances i reach the
2gb limit and all goes to pieces. So i cant really compact, delete some,
compact, delete some, compact, etc?
 
Back
Top