Displays optimizer statistics or loads updated statistics into system tables.

optdiag [binary] [simulate] statistics { -i input_file | database[.owner[.[table[.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]

Parameter information :

»	binary : extracts statistics in human-readable form and in binary form. When used with an input file (-i input_file), loads binary statistics into system tables.
»	simulate : specifies that optdiag display or load simulated statistics.
»	-i : specifies the name of the operating system file to use for optdiag input.
»	database : is the name of the database whose statistics you want displayed.
»	owner : is the name of a table owner.
»	table : is the name of the table to survey for statistics.
»	column : is the name of the colum to survey.
»	-o : specifies the name of an operating system file to store the output from optdiag.
»	-U : specifies an ASE login name.
»	-P : specifies your ASE password.
»	-T : sets trace flags for the optdiag session.
»	trace_value : The optdiag trace flags are: Possible values: 1 : Do not stop with a warning if the optdiag version of ASE in use does not match the Adaptive Server version in the input file., 2 : Display status message 'Next table is table_name' when in input mode., 4 : Skip consistency checking for step numbers while loading histograms in input mode., 6 : Display lines of input file during input mode. This flag has no effect in display mode.
»	-I : specifies the name and location of the interfaces file to use when connecting to ASE.
»	-S : specifies the name of the ASE to which to connect.
»	-v : Print the version number.
»	-h : displays the optdiag syntax help.
»	-s : includes system tables in optdiag output.
»	-z : is the official name of an alternate language that the server uses both for date formats and to display optdiag prompts and messages.
»	-J : specifies the character set to use on the client.
»	-a : runs optdiag from a terminal with a character set that differs from that of the machine on which optdiag is running.