R8 – A column being referenced has not been indexed. This may be a performance issue (WMB)

A column being referenced has not been indexed. This may be a performance issue (WMB)

The MB-Precise plugin will attempt to validate your ESQL and MsgFlow code against any databases that the code is using. If the plugin detects database access code (a SELECT, DELETE, INSERT, UPDATE), it will attempt to validate that the tables and columns that the SQL is referencing are valid and consistent. This warning indicates that columns that a table are being accessed by are not indexed.

For example   SET LocalEnvironment.Variables.SelectData[] = PASSTHRU(‘SELECT Name, Age, Height ‘ ||
       ‘FROM THEDATA.PersonTable’ ||
       ‘WHERE Wieght > ?’, weight);

This may or not be an issue depending upon the table being accessed size and the frequency of access. Analysis of the amount of expected data in the tables affected should be undertaken with the DBA to see if this will be an issue in a production system.