Visual Expert collects and presents certain information about the code and database in production, which can help optimize 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 Frequently 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 Referenced Objects
Identify the objects that are most frequently used/referenced by code.
Follow this tutorial to apply it to your code.