Totally unacceptable non-performance
21 million records in file geodatabase table
Selecting by a single attribute ADDRESS_TYPE = 'A' via Make Feature Layer. Deleting with Delete Features outside of edit session. Eerily, the Make Feature Layer takes seconds - did it fail?
The attribute has an attribute index built on it.
18% complete is 2.5 hours.
I manually selected the same records from the attribute table in a different copy of the data. Then ran Delete Features outside an edit session. Performance similarly slow.
What can be done?
Suggestions welcome. Simply cannot do my job with 10.0 without speed up. Previously such operations were not impossibly slow.