![]() |
I have data such as the following:
26 May 2016
| 5 comments
,
|
![]() |
/*I have two views in a company’s HR database I am pulling from. One gives a list of hiring actions. The first time an employee is hired, they’re given a sequence of 1. Each time after they’re given a sequence of 2, 3, 4 and so on. The second view I’m querying has similar information for employees who were terminated.
15 Mar 2016
| 3 comments
,
|
![]() |
Teradata partitioning was originally released in V2R5.0. This presentation reviews partitioning and the changes to this feature (from DPE to columnar) that have occurred over the last twelve years.
06 Aug 2015
,
|
![]() |
Hi all,
26 Jan 2015
| 1 comment
,
|
![]() |
Posted this on latest Paulsinclair blog post (2012) but I guess I'll it a try here :
16 Oct 2014
,
|
![]() |
All of our tables have effective start and end date columns (EFF_STRT_DT, EFF_END_DT). We want to create date partitions on some of our larger tables, and our fist instinct is to create the partition on EFF_END_DT, because we set that date to '9999-21-31' to represent "active" rows in our data warehouse.
11 Aug 2014
| 8 comments
,
|
![]() |
Hi All,
04 Jun 2014
| 3 comments
,
|
![]() |
Hi,
16 Jan 2013
| 2 comments
,
|
![]() |
|
![]() |
I've just started playing around with column partitioning in R14. I created a table using a recent example that Paul Sinclair put into a recent Teradata Magazine article:
25 Jul 2012
| 1 comment
,
|
![]() |
Hi, I have a tableA with partition given below,
PARTITION BY ( CASE_N( sys = 1, sys= 2, sys= 3 NO CASE OR UNKNOWN),CASE_N( cyc = 1, cyc= 2, cyc= 3 NO CASE OR UNKNOWN) );
01 Jul 2012
| 1 comment
,
|
![]() |
All All, I have a PPI table paritioned by end_dt
19 Apr 2012
,
|
![]() |
Accurately identifying how much a table has grown since statistics on a column were last collected is an important prerequisite for the statistics extrapolation process. Once table growth has been detected, then stale statistics can be adjusted accordingly. Extrapolations based on table growth will be be more accurate if statistics are being regularly collected on the system-derived column PARTITON, whether or not a table is partitioned.
17 Feb 2012
| 7 comments
,
|
![]() |
Hi, Is there any way to partition directly on a small (ie. CHAR(3)) character column, without defining a CASE_N or RANGE_N for the column (ie. partition on all unique values of the column)?
04 Oct 2011
| 1 comment
,
|
![]() |
What is the best way to extract the output of the 'Help statistics DbName.TblName column Partition;", for the purpose of extracting the value of the column 'Number of Rows'. If you have attempted this through SQL, please share your thoughts. What I've already have in place is the following methodology...
26 Sep 2011
| 7 comments
,
|
![]() |
Is there any other way of reliably tell the optimizer to use the PPI other than hard-coding the minimal/maximal value (date) in a following case? Here is a DDL for a big table with customer transactions: transaction_table
11 Jul 2011
| 2 comments
,
|