Temporary table should have indexes
- Indexing is reasonable if: 1.1 A large temporary table is involved in a join (regardless of on which side). Add fields involved in the BY condition to the index. 1.2 A temporary table is called in a subquery of the construct of the logical IN (…) operator. To the index, add fields of the temporary table from a selection list that match fields listed on the left side of the logical IN(…) operator.
- You do not need to index small temporary tables consisting of less than 1,000 records.
Noncompliant Code Example
Compliant Solution
See