How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

Number format in explain plan

[This topic is migrated from our old forums. The original author name has been removed]

When using explain plan, the value of total cost (or other value), is very often very high like 28736122, and it is really hard to read such numbers, but "28 736 122" is much more easy to read, so is there a way to set number format for results of explain plan ?
8 CommentsSorted by Oldest First
[This reply is migrated from our old forums.]

Re: Number format in explain plan
The format for these numbers can be changed by changing the "Decimal Number Format" property. The property can be found in Tool Properties->General Properties->Data Formats.
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: Number format in explain plan
It didn't help those setting only applies to results from select shown in datagrid but not to explain plan results
[This reply is migrated from our old forums.]

Re: Number format in explain plan
Sorry, should have seen this. Thanks for putting our attention on this. It will be fixed in the next feature release.
[This reply is migrated from our old forums. The original author name has been removed]

Re: Number format in explain plan
Cool, it would be also useful if those format settings would be separated for result from data grind and explain plan, because for explain plan the format is purely for readability but from datagrid are very often data copied and used elsewhere, therefore format matters much more.
[This reply is migrated from our old forums.]

Re: Number format in explain plan
Hi, The formatting in explain will be static since it as you say is for readability. Regards Roger
[This reply is migrated from our old forums.]

Re: Number format in explain plan
Hi, We just launched the BETA testing of the upcoming 9.5 version with a few enhancements in explain plan and its formatting of numbers. It would be great if you can give it a test and verify. http://www.dbvis.com/download/beta/ For more information about the news in the BETA version: http://www.dbvis.com/doc/relnotes/index.jsp?showheader=false&showtoc=false&version=9.5-BETA We plan to go public with 9.5 in a few weeks. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Number format in explain plan
It is definitely improvement in terms of readability

I just wanted to let you know that we released DbVisualizer 9.5 yesterday with a fix for the issue you reported. Easiest way to upgrade is that you open Help->Check for Update in DbVisualizer to perform the upgrade.


An alternative is that you download from our web site: 


http://www.dbvis.com/download/


Best Regards,

Hans

Login or Signup to post a comment
More topics in Support
See all 1297 topics