Teradata Cookbook
上QQ阅读APP看书,第一时间看更新

There's more...

Here are some effects of skew PI:

  • Running out of space on a database: Database space is equally distributed across all AMPs on a Teradata system. If your database runs out of space, it could be out of space on just one AMP because of a skewed table. 
  • Running out of spool: At runtime, if data is skewed on a join, one of the AMPs can run out of space, causing the query to fail.
  • High runtime: Skew queries tend to run more, as one of the AMPs works more than the other.