[EMAIL PROTECTED] wrote:
I will need an index on that field later, but
I could drop it prior to the delete and create
a new one after.
Don't do that. If you need the index, then leave it as is.
Thinking about it I am not sure in any case of the
value of an index after deletes on a table.
Is it usually better to re-index after deletes?
Indexes are updated automatically as records are added and deleted from
a table, that's why they add overhead if they are not serving some
purpose. Your index will be correct after you delete the records from
tableB.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
