Sybase Question:
Download Questions PDF

When should I execute an sp_recompile in Sybase?

Answer:

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.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
When are stored procedures compiled in Sybase?Alternative to row at a time processing in Sybase?