The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Can't find if env is 'SqlCmd' or 'FreeTds' !
Sourcing sqwmsq_Global.lib v2025.04 SQWareProduction for MsSql (dbSQWare) ...
Usage: sqwmsq_RebuildIndexDatabase.ksh [-h] -I <FreeTdsAlias> -D <DatabaseName> [+ options]
DESCRIPTION
sqwmsq_RebuildIndexDatabase.ksh Rebuild index of database
SUPPORT
MsSql supported versions: 2000 <= v <= 2022
PARAMETERS
-I Instance : Target instance (freeTds alias).
-D databasename : Target database.
OPTIONS
-h : Display the full usage.
-s : Display samples of usage.
-IT listtables : List of tables to run update statistics on (by default all).
-ET listtables : Tables list to exclude.
-IL likeclause : Like clause to generate tables list (example: 'tbl%').
-EL likeclause : Like clause to exclude tables (example: 'notbl%').
-WCT whereclause : Where clause to generate tables list.
-FRT code : Force return code value on error.
-AddMail email : Email address to add at 'demo-sqwarebox@dbsqware.com'.
-RebuildType type : Type of rebuild, 'all' for table, 'index' for indexes (by default 'index').
-MinRatioReb ratio : Min avg_fragmentation_in_percent before rebuild (by default 30 %).
-MinRatioRgz ratio : Min avg_fragmentation_in_percent before reorganize (by default 10 %).
-SizeMaxIndex Size : Take into account indexes <= $gvsqw_SizeMaxIndexRebuild Mb (by default, 50000 Mb).
-SizeMinIndex Size : Take into account indexes >= $gvsqw_SizeMinIndexRebuild Mb (by default, 1 Mb).
-SendReport : Send execution log report.
-SortInTempdb : Rebuild with option sort_in_tempdb=on.
-Online : Rebuild with option online=on.
-Force : Force Rebuild offline if necessary when -Online.
-NoMail : Deactivate sendmail on error demo-sqwarebox@dbsqware.com (by default, send on error).
-Locale locale : Force Locale for help display (fr,en).
-Flag filename : Fichier a chercher.
-Exec : Execute commands (by default, display generated commands).