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:

• The table will contain a small number of records. The auto-generated stored procedures won’t dramatically improve the performance, but will take up additional space in the database and increase the time required to create the table.
• The table is a temporary table. Typically, temporary tables are used once and then deleted. Creating the stored procedures increases the time required to create the temporary table, but they provide little benefit because most of them won’t be used to access data before the table is deleted. This is especially true of small temporary tables and temporary tables that will be used for reports.

Documentation Feedback

---