When should I execute an sp_recompile in Sybase?
Submitted by: AdministratorAn 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Sybase Job Interview Questions And Answers
Top Sybase Questions
| ☺ | What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase? |
| ☺ | How to pad with leading zeros an int or smallint in Sybase? |
| ☺ | Explain about the features of Sybase IQ? |
| ☺ | How can I execute dynamic SQL with ASE in Sybase? |
| ☺ | Explain about Power Designer Data modeling software? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
