Optimization of Attributes to Publish

SQL Access databases created by the Sigmafine SQL Access over a SQLServer instance are composed by a set of tables where each table holds the data of a well-defined Sigmafine asset template. Those tables are created by default and with the necessary columns in order to record all of the template attributes.

In some cases, not all of the Attributes are used by the Sigmafine analysis or some of them are not necessary for the business scope of the SQL Access publication. In those cases, it is good practice to select for each Sigmafine template the subset of Attributes covering the business needs. This is much to the advantage of the recorded data’s quantity.