TempTable [name] defined like [table] has no index defined.

Rule "ttnoindex" gives this warning when it finds a DEFINE TEMPTABLE statement that is defined LIKE another table but doesn't contain the USE-INDEX statement and hasn't defined an index.

The risc:

If the LIKE table has a large list of indexes then the temptable will inherit all those indexes, thereby increasing the overhead.

Known issue:

The TempTable definition may be like another temptable or table definition that has only the indexes that are needed.

How to solve this:

Make a habit of specifying the exact indexes that the program will be using regardless of whether they are the same as the LIKE table.

How to suppress these warnings:

You can put directive {&_proparse_prolint-nowarn(ttnoindex)} directly before the DEFINE keyword. See also: suppress warnings.