Using Temp Tables

Consider these issues when using temp tables:

• Use temp tables only in cases where they significantly improve the performance of a detection process. Test the performance of the job with and without the temp table to ensure that the temp table shortens the completion time substantially.
• Never use temp tables with the Rule Matcher detection tool. The Rule Matcher can access data incrementally, retrieving records only for those entities that satisfied the conditions specified earlier in the pattern. This capability obviates the need for temp tables.
• Note that data records cannot be matched directly from temp tables. All datasets used in detection must have a KEY_ID that is derived from one of the business tables in the data mart. The user interface does not have any means of displaying a record that is matched out of a temp table.