Hadn't thought of that - I'll investigate. Thanks Dave. The purpose of the index is just to quickly find if a table needs packing as there are functions which automatically delete records if the content falls below a specified level.
John Weller 01380 723235 07976 393631 > > John and others, > Why not use the "for deleted()" expression in the index to create > a filtered > index. > > That way you get the smallest index size as one would assume that > the number > of deleted records are always minimal in comparison to the main "live" > records and maximum performance which far outweighs the inability to use > Rushmore in filtered indexes. > > I have used this method for many years with no problems. When you need to > find a deleted record the index data transferred is minimal over > the Lan and > the index is not bloated from useless live records. > > After all the reason for having a deleted index is only to find deleted > records to re-use. > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
