Opserver icon indicating copy to clipboard operation
Opserver copied to clipboard

Sql query plan index details shows scientific notation that is longer than base10 number

Open johnmwright opened this issue 5 years ago • 0 comments

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: image

If preferred, I can provide a live example from the internal Stack Overflow opserver.

johnmwright avatar Nov 06 '19 20:11 johnmwright