Re: Cutting the Database file size

> > I have some database files that have been accumulating data > for about two years and I would like to make them smaller. I have > deletet items from before last year and did a re-indexing but the > file is still 38Megs. I can't find a way to make the size smaller. Try altering the primary Index on this table to cluster. This will rebuild the table in the order of the primary key thereby removing all deleted data. Use the following syntax :- ALTER INDEX indexname TO CLUSTER; ----------------------------------------------------------------------------- Steve Weet - European Mis - Motorola Cellular Subscriber Group Beechgreen Court, Chineham, Basingstoke, HANTS England. Phone : +44 (0)256 790154 E-Mail stevew@chineham.euro.csg.mot.com Fax : +44 (0)256 817481 Mobile : +44 (0)850 335105 Post : w10075