0 - 12 of 12 tags for skew

Am looking for some insights on setting appropriate CPU Skew Exceptions using Workload Designer.  Current VP version 15.11, Teradata 15.0.

I downloaded this Geospatial Shapefile:
https://www2.census.gov/geo/tiger/TIGER2015/UAC/
 
The table that was created by loading the shapefile looks like this:

Hi
As spool file is one of the usual issue of complex queries or queries run upon large data sets, It would be good to have chance to look at skew of spool files. If it was a chance to somehow check/calculate skew of spool file - even if it is per query and steps of the query, it would be more than useful.

Hi Experts,
My loads are failing because the database is running out of space. When I checked the table size of the table being loaded it shows it is occupying 90GB(including the skew). Whereas the table has zero records in it. Can you please let me know what exactly is causing the table to occupy 90GB of space even when it has no  rows in it.

Everyone is taught how to collect statistics in order to make Teradata queries run well but what if you've collected all the statistics that you can and you STILL have bad performance?

Calculation Skew
I have some problems calculatine Skew base don column combinations. I found something like this:

As part of the Viewpoint 15.00 release, the Viewpoint team built a brand new version of the Node Resources portlet.  The primary purpose of this portlet continues to be to identify skew on a Teradata Database system.  The original incarnation of this portlet required a fair amount of manual intervention in order to achieve this goal.  The new version of this portlet includes a simpler user interface and a new algorithm to identify skewed resources (or “outliers”) automatically.

Hi All,
I have a table that has PI consisting of Col_A and Col_B. Col_C is a timestamp(6) field which is a PPI.
As per the current data, the table has a skew factor of 75%.
Therefore, I created an identical table, this time with PI consisting of Col_A, Col_B and Col_C, with Col_C again as PPI.

Hi All,
I have a table that has PI consisting of Col_A and Col_B. Col_C is a timestamp(6) field which is a PPI.
As per the current data, the table has a skew factor of 75%.
Therefore, I created an identical table, this time with PI consisting of Col_A, Col_B and Col_C, with Col_C again as PPI.

Hi All,
I was reading Carrie's blog on skew sensitivity of TD12 optimizer.
http://developer.teradata.com/database/articles/skew-sensitivity-in-the-optimizer-new-in-teradata-12
 

Please expalin in detail how exactly we are getting total size of the DB and the free space in the DB.
Query used to find the free space.

I am trying to understand the following steps from an explain of a massively skewed query.
The "no confidence" is because of the calculations and functions applied to the columns.
Would appreciate if someone could correct my understanding.
It's a 2650, 219 amps system.