SQL Auto Procedure Disable Options

These options allow you to disable creation of the auto-generated stored procedures for specific table operations. In special circumstances, disabling the auto-generated stored procedure for a particular table operation can improve the performance of the application. Refer to Auto-generated stored procedures for more information about auto-generated stored procedures.

Auto-generated stored procedures provide the greatest performance benefits in tables with more than 100 records. The benefit is less significant for small tables. Creating auto-generated stored procedures also adds to the time required to create a table. Based on these two factors, you may want to disable the creation of the auto-generated stored procedures if the table meets one of the following criteria:

Documentation Feedback