DeleteFeatures no longer deletes all records at one time which it's supose to do when the input is a feature class or table! We upgraded from ArcGIS 10.0 / SQL 2008 to ArcGIS 10.1 / SQL 2012 so I don't know which caused the change. In 10.0 this was carried out all at once in like a truncate on the database side, but after upgrading it's taking forever now. Through SQL Profiler I can see that the records are being deleted in batches of about 150 records at a time, so what use to take about 2 to 3 seconds now takes over 30 minutes for a feature class containing a 1,000,000 records. Is there any fix for this?
BTW, this is similar to a bug introduced back in 9.3.1
-- sample from SQL profiler --
declare @p1 int
exec sp_prepexec @p1
output,NULL,N'DELETE FROM GEOLIB_STAGE.DBO.TRANS WHERE OBJECTID IN
The 'Delete Features" or "Delete Rows" have always been deleting one record at a time. So what you may be observing is a performance degradation w.r.t. the tool.
Is your data registered as Versioned? If not, you may try the Truncate table tool. It deletes all the records in a table\fc in one go.
Note: Try to post your question with proper tags to get a wider audience.
enterprise gis sdesdemanaging_datageodatabasearcgis sdeenterprise geodatabases (arcsde)gp tools
No it's not versioned. I just saw the Truncate Tool under Data Management Tools | Tables but it's not under Features so I missed it. (But I am disappointed I have to modify all my scripts and models after ESRI changed the behavior of a tool.)