For help, water treatment, how to query the table, the water level space is much higher than the act-CodePudding

Home > database > For help, water treatment, how to query the table, the water level space is much higher than the act

For help, water treatment, how to query the table, the water level space is much higher than the act

Time：10-01

How to query the table, the water level is higher than actual use space a lot?

CodePudding user response:

 
- collect all the tables of statistics, execute this again, the second column is probably need data blocks, the third column is the actual blocks 
The select table_name, avg_row_len * num_rows/8192, blocks 
The from user_tables

Page link：https//www.codepudding.com/database/45118.html

Prev:Select the top problem

Next:ALinq connect to the database failed. Is it possible to shorten the prompt time.

Tags：

Infrastructure and management

Links：
CodePudding