Visual Expert (VE) can tell you what tables take up the most space in your Oracle or SQL Server database in terms of row count or volume (size) of data.
How to find largest tables in your database using Visual Expert?
1. By Row Count: Sort the tables by number of records.
- Select the root of the tables in the treeview to make this feature available.
- Click on ‘Table Row Count’ in the navigation bar.
The tables will be listed with the number of records displayed beside them in descending order.
- To limit the number of tables displayed, click the ‘wrench’ icon to open the macro options window.
- For example, this configuration will list the top 10 tables containing the biggest number of records in the database.
2. By Volume of Data: Sort tables by size (MB)
- Select the root of the tables in the treeview to make this feature available.
- Click on ‘Table Size’ in the navigation bar.
The tables will be listed with the size of data displayed in MBs beside them in descending order.
- To limit the number of tables displayed, click the ‘wrench’ icon to open the macro options window.
- For instance, this configuration will list the 10 largest tables in the database.
SEE ALSO:
- Review production metrics and statistics to optimize code performance
- A step-by-step tutorial to improve code performance with Visual Expert