0 - 12 of 12 tags for skew
Workload Designer - CPU Skew Exceptions

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

By dnarva, 02 Sep 2016 | Tagged: workload designer skew exceptions tasm tdwm
Reduce skew on a table with Shapefile data?

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:

By teradatatester, 21 Jun 2016 | Tagged: geospatial skew shapefile primary index index
Analysis of skew of spool files

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.

By dagen, 15 Dec 2015 | Tagged: spool skew query performance | 1 comment
Table occupying space without any rows

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.

By Abdulaziz, 06 Aug 2015 | Tagged: database spaces skew loading #TPT #Informatica | 3 comments
Dealing with Natural Data Skew

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?

By DebraH, 02 Mar 2015 | Tagged: skew performance tuning physical design query tuning
Calculation Skew

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

By PeterSchwennesen, 07 May 2014 | Tagged: skew | 3 comments
Node Resources Portlet - Take 2

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.

By stever, 25 Apr 2014 | Tagged: viewpoint portlet Node skew resources v_viewpoint | 11 comments
Using a PPI column in PI

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.

By aarsh.dave, 20 Jan 2014 | Tagged: pi ppi data modeling skew | 2 comments
Using a PPI column in PI

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.

By aarsh.dave, 20 Jan 2014 | Tagged: pi ppi data modeling skew | 4 comments
Query on Skew-Sensitivity in the TD12 above Optimizer

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
 

By Santanu84, 25 Dec 2013 | Tagged: optimizer skew database | 2 comments
Can someone please explain the below query in detail?

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.

By barani_sachin, 18 Dec 2012 | Tagged: skew total size free space | 2 comments
all-AMPs STATS FUNCTION

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.

By SANJI, 04 Dec 2012 | Tagged: skew all amps stat function