Output displays in hexadecimal not in binary.
Because precision can be lost with floating point numbers, optdiag provides a binary option. The following command displays both human-readable and binary statistics:
optdiag binary statistics pubtune..titles.price -Usa -Ppasswd -o price.opt
In binary, any statistics that can be edited with optdiag are printed twice, once with binary values, and once with floating-point values. The lines displaying the float values start with the optdiag comment character, the pound sign (#).
This sample shows the first few rows of the histogram for the city column in the authors table:
Step Weight Value 1 0x3d2810ce <= 0x41504f204d69616d68ffffffffffffffffffffff # 1 0.04103165 <= "APO Miami\377\377\377\377\377\377\377\377" 2 0x3d5748ba <= 0x41746c616e7461 # 2 0.05255959 <= "Atlanta" 3 0x3d5748ba <= 0x426f79657273 # 3 0.05255959 <= "Boyers" 4 0x3d58e27d <= 0x4368617474616e6f6f6761 # 4 0.05295037 <= "Chattanooga"
When optdiag loads this file, all uncommented lines are read, while all characters following the pound sign are ignored. To edit the floating-point values instead of the binary values, remove the pound sign from the lines displaying the floating-point values, and insert the pound sign at the beginning of the corresponding line displaying the binary value.