Hot answers tagged overlay
You can't efficiently delete large numbers of features from a large table, period. You'd be much better off just marking them as deleted (available varchar(1), values 'Y' or 'N') and adding an attribute constraint to your selection logic (or using a view). Building a parallel table to house a foreign key and available field is an adequate solution, though ...
Only top voted, non community-wiki answers of a minimum length are eligible