dbFront 1.4.0.0320, includes a tool that helps analyze the loading impact of view columns on the table grid.
This functionality currently only works for SQL Server.
The View Analyzer is accessed from the [Tools] tab on the Table Preferences. This only analyzes views that have columns that appear on the Table Grid. If the view's columns don't appear on the Table Grid, then that view can't have any impact on the loading performance so the View Analyzer won't report anything for that view.
dbFront will analyze the view by running multiple queries against the view and comparing the performance for each selected column. The currently selected table record will be used to drive most of the queries, so if a different record would affect the view logic then you will need to test with multiple table records.
dbFront will return the SQL Server-provided statistics in a formatted grid for easy comparison.
