When showing the details table on an index in the sql query plan, some of the numbers display in scientific notation (ex: 1.80534e+007) even when the base10 number would take up less space (ex: 18053400).
In my opinion, there are few, if any, cases where the scientific notation would be preferred over the more-human-readable base10 notation, so I would suggest that the display logic be modified to force a non-scientific-notation output in all cases.
Example:
If preferred, I can provide a live example from the internal Stack Overflow opserver.
When showing the details table on an index in the sql query plan, some of the numbers display in scientific notation (ex:
1.80534e+007) even when the base10 number would take up less space (ex:18053400).In my opinion, there are few, if any, cases where the scientific notation would be preferred over the more-human-readable base10 notation, so I would suggest that the display logic be modified to force a non-scientific-notation output in all cases.
Example:
If preferred, I can provide a live example from the internal Stack Overflow opserver.