| |||||
![]() |
![]() |
![]() |
|||
|
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.
(Continued on next question...)
Other Job Interview Questions
|
||||
![]() |
![]() |
![]() |
|||