Execution Plans for Resource-Intensive Queries Product join
Resource-intensive queries can have a bad execution plan for a number of reasons, such as:
a、Stale statistics
b、No statistics on a skewed, highly nonunique index
c、Poor choice of a primary index
d、Poorly written SQL, particularly with missing join constraints
Teradata执行计划中比较少product join ,比较常见的问题是 PI设置错了。
Resource-intensive queries can have a bad execution plan for a number of reasons, such as:
a、Stale statistics
b、No statistics on a skewed, highly nonunique index
c、Poor choice of a primary index
d、Poorly written SQL, particularly with missing join constraints
Teradata执行计划中比较少product join ,比较常见的问题是 PI设置错了。
