When should I execute an sp_recompile in Sybase?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

When should I execute an sp_recompile in Sybase?

An sp_recompile should be issued any time a new index is added or an update statistics. Dropping an index will cause an automatic recompile of all objects that are dependent on the table.

The sp_recompile command simply increments the schemacnt counter for the given table. All dependent object counter's are checked against this counter and if they are different the SQL Server recompiles the object.

(Continued on next question...)

Other Job Interview Questions

• What's a natural key?in Sybase
• How do I run multiple versions of Sybase on the same server?
• How do I check if log truncation is blocked in Sybase?
• How to view the log files in sybase
• We have lost the sa password, what can we do?
• How do I check if log truncation is blocked in Sybase?
• Hiding your password to isql in Sybase
• How Do I Take Advantage of Table Partitioning with bcp in Sybase ?
• What are the vital features of Sybase?
• Explain the benefits you can get from Mainframe connect?
• More...