Hotspot filters

"Hotspots" are areas in an extract trace file where the amount of data read or extracted, for example, is either more or less than expected. By specifying a rule or combination of rules on the Extract Hotspot Filter View, you can visually identify areas of the extraction process that are candidates for optimization. The following rules are provided:

• No rows read from object: Select this rule to highlight only objects from which no rows were read.
• No rows read from object in any event: Select this rule to highlight only objects from which no rows were read during any of the events involving that object.
• No rows extracted from object: Select this rule to highlight only objects from which no rows were extracted.
• No rows extracted from object in any event: Select this rule to highlight only objects from which no rows were extracted during any of the events involving that object.
• Objects with more than __ rows read: Select this rule and type a number in the box to highlight only objects from which more than the specified number of rows were read.
• Objects with more than __ rows extracted: Select this rule and type a number in the box to highlight only objects from which more than the specified number of rows were extracted.
• Greater than __ percent of rows read: Select this rule and type a number in the box to highlight only objects from which more than the specified percentage of rows were read.
• Greater than __ percent of rows extracted: Select this rule and type a number in the box to highlight only objects from which more than the specified percentage of rows were extracted.
• Objects with more than one parent: Select this rule to highlight only objects that have two or more parents.
• Objects that reference themselves: Select this rule to highlight only self-referencing objects.
• Objects visited more than __ times: Select this rule and type a number in the box to highlight only those objects that were accessed more than the specified number of times during the extraction process.
• Top __ percent by CPU consumption: Select this rule and type a number in the box to highlight only the specified percentage of those events that consumed the most CPU time.
• Tables that may need RUNSTATS run: Select this rule to highlight only objects for which the RUNSTATS utility may need to be run.

Rule selections generally take effect immediately. To apply a rule in which a value has been typed, either press Enter or click the Apply button at the bottom of the view. To reset all of the rules in the Extract Hotspot Filter View, click the Clear button at the bottom of the view.