Explain Plan: wrong value in COST significant zero numerals are cut off with German separator setting
1. For the German Toad is set "." as Thousand separator and "," as Decimal Separator.
2. In the SQL of the Explain-Plan coming directly from the database you see in the column COST
5.241
5.241
5.240
in TOAD this is shown as:
5,241
5,241
5,24
==> This is wrong because 5,24 (even in American/UK format) has to be written as "5,240" (because the value is "5240")
as COST only can be an integer (whole number)
WORKAROUND:
None
STATUS:
Waiting for a fix to be released in a future version of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy