Modèle:SQWareProduction sqwmsq RebuildIndexDatabase.ksh presentation : Différence entre versions
m (Updated by BatchUser) |
(Aucune différence)
|
Version du 14 avril 2019 à 19:05
Generate reorganization commands for the database
version = 2000 -> Dbcc dbreindex (N'[$lvsqw_Owner].[$lvsqw_TableName]',,90)
version >= 2005 -> alter index all on [$lvsqw_Owner].[$lvsqw_TableName] Rebuild with (online = off)