>Hi All,
>
>What were the recommendations about creating an index on DELETED() records? Given a file of, say, 1 million records of which 10% might be deleted is it a good or bad idea to index on DELETED()?
>
>TIA

Hi Jos,

All of tables of mine has an index on deleted()

I never use pack command. This is my record append function:

Local ord,onerr
ord=Order()
onerr=On("erro")
Nodele=.F.
On Error Nodele=.T.
Set Order To Delete
If Empty(m.onerr)
	On Error
Else
	On Error &onerr
Endif
If Nodele
	Append Blank
Else
	Set Deleted Off
	If Seek(.T.)
		Recall
		Blank
	Else
		Append Blank
	Endif
Endif
Set Order To &ord
Set Deleted On

You have to use flock() before use that function because of record get violations.