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)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center