When marking a tablename there is displayed like a smalle progressbar on the right hand side with the tablesize written on top of it - what does this progressbar show me?
I haven't been able to get any info about this anywhere so now I have to ask here.
What does the bar show me?
Nope, I don't think so.
If you look each column (row count and size count) you will have one that is 100% filled by green bar and it is the biggest count/size number, other green bars have % width calculated on this biggest count/size value.
So if you have the biggest record count that is 500 on table "TB1" then it will be get full filled green bar, and if there is a 250 records in "TB2" then green bar width will be 50% as 250 is 50% of the 500 max record count.
If all count or sizes are equal then all green bars will be 100%.
Of course I can be wrong but if you look I think my explanation is correct.
If you look each column (row count and size count) you will have one that is 100% filled by green bar and it is the biggest count/size number, other green bars have % width calculated on this biggest count/size value.
So if you have the biggest record count that is 500 on table "TB1" then it will be get full filled green bar, and if there is a 250 records in "TB2" then green bar width will be 50% as 250 is 50% of the 500 max record count.
If all count or sizes are equal then all green bars will be 100%.
Of course I can be wrong but if you look I think my explanation is correct.
dodfr is rightNever thought about that in percentages yet. I had introduced that to have a visual hint to the used disc space in a database.
Probably not known by many users: Once you have clicked/expanded all databases in your session, the top root node will show you the overall used space on your server.
You can however disable these size bars, in Tools > Preferences > Miscellaneous.
Probably not known by many users: Once you have clicked/expanded all databases in your session, the top root node will show you the overall used space on your server.
You can however disable these size bars, in Tools > Preferences > Miscellaneous.
Please login to leave a reply, or register at first.