optdiag

Displays optimizer statistics or loads updated statistics into system tables.

The utility is located in:
  • (UNIX) $SYBASE/$SYBASE_ASE/bin.

  • (Windows) %SYBASE%\%SYBASE_ASE%\bin, as optidag.exe.

Syntax

optdiag [binary] [simulate] statistics
	{ -i input_file | database[.owner[.[{table|prs_name}[.column] ] ] ] 
	[-o output_file] }
	[-U user_name]
	[-P password]
	[-T trace_value]
	[-I interfaces_file]
	[-S server]
	[-v]
	[-h]
	[-s]
	[-z language]
	[-J client_character_set]
	[-a display_charset]

Parameters

Examples

Related concepts
Utility Commands Reference
Related reference
ddlgen