With the Aeros ERP database, there are many tables and many columns. When creating Aeros VISION queries, all table/column objects associated with the query’s Data Model are displayed on the left in the Entities Section.
By default, each time a query is opened for editing, all tables and columns are displayed whether the query is referencing each table or not. This takes up real estate as well as uses un-necessary resources.
Aeros VISION has included optimization features to make your VISION queries and Data Models easier to view and understand, as well as improve performance.
Pre-Requisites
- It is recommended that you have a basic understanding of creating VISION Queries and Data Models.
Step-by-Step Guide
To Optimize an Existing Query Data Model:
- Log into Aeros VISION
- Select the query to be optimized and click the pencil icon.
