Hi!
I guess yes. However, why not PACK thais table so deleted records go away? Common practice is making the service running at the serevr that do nightly maintenance operations: check for corrupted tables, reindex and pack all tables etc.
>I have a table that has around 66% deleted records, and is accessed with SET DELETED ON.
>
>Users complain it is slow when accessing it.
>
>Would it be wise to add DELETED() Tag?
>
>Thanks
>Kev
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.