How to delete data from MS SQL Server using Delete from Data Store Entities Smart Service ?

Question

What are the steps/best practice to delete data from external DB table using Delete from Data Store Entities Smart Service ?

santoshd378 · Accepted Answer

The entities need to be point out with constants(You need to create a constant to access the entity)

naveenp878 · Answer

We can use the OOTB smart service for deleting the data/records from external DB table. It is very useful for limited set of data. But when you have a requirement to delete huge data (say more than 10 records for example), as per the database best practices and to do more graceful way is - create stored procedure to delete the records and let the database to handle the entire deletion operation instead of Appian. This can be done using the plugin smart service - "Execute Stored Procedure". This makes more efficient operation than using regular data store entity smart service especially in bulk deletion operations. 
 
for more details please visit the play book - community.appian.com/.../database-performance-best-practices 
 
For shared component - forum.appian.com/.../summary