Informix Error -2845
-2845 The composite column for table table-name containing
column column is not indexed. Performance will be much improved by creating an index on the column.The presence of an index can greatly reduce the time that is needed to join tables. However, an index is not essential, especially when the tables are small, or during initial testing.