Visual Expert collects data about the volume and execution time of certain objects. It combines them with a static analysis of the code to help improve performance.
Visual Expert can answer the following questions:
Largest Tables by Number of Rows
Sort tables by size, depending on their number of records, as shown below.
Follow this tutorial to apply it to your code.
Largest Tables by Size (Volume of Data)
Sort tables by size, depending on their volume of data.
The result shows the size in MBs beside each table, as shown below.
Follow this tutorial to apply it to your code.
Most Executed Objects
Identify the most frequently executed objects in your database.
Should you engage in an optimization process, you may want to prioritize these objects, since they are executed more frequently than others.
Follow this tutorial to apply it to your code.
Most Used Objects
Identify the objects that are most frequently used/referenced by code.
Follow this tutorial to apply it to your code.
Table Information
List tables with their size and row count, as shown below.
Follow this tutorial to apply it to your code.