OctoSAM query concepts (preview)¶
OctoSAM queries are used throughout OctoSAM whenever data needs to be presented in a tabular form.
Naming conventions¶
Columns in grids keep their database names whenever possible.
PrintableName column¶
Many tables have a PrintableName column. The values are constructed by OctoSAM based on other key columns of the table. The PrintableName is the name that is often shown for objects outside the grid. Within grids, the column usually has the name of the main object. For example, Machine.PrintableName is displayed as Machine.
CurrentDateTime column¶
Most queries contain a hidden CurrentDateTime column that contains the start time of the query
Dummy column¶
Some queries need a Dummy column to make sure the SQL syntax stays valid even with variable number of columns. This column is usually not displayed at all.
Query performance aspects¶
Performance of a query depends on the amount of data selected, the complexity of the query and the configuration of the database.
Keep indexes current¶
Consult with your DBA on strategies to keep indexes and statistics up-to-date.