![]() |
I downloaded this Geospatial Shapefile:
21 Jun 2016
,
|
![]() |
I have a transactional dataset which has a date field, my query is whether it is better to bring in the date field into the PI for the table i am using or leave it out. The PI is currently made up of a product unique identifier which is duplicated for each date related to the product.
26 Apr 2016
| 2 comments
,
|
![]() |
Hi,
03 Oct 2015
| 3 comments
,
|
![]() |
|
![]() |
Hi All, I am doing physical Database design in my project. LDM(3rd normal form relation model) is done and I am in the process of selecting primary index for the tables.
26 Apr 2015
,
|
![]() |
Hi all,
26 Jan 2015
| 1 comment
,
|
![]() |
Hi All,
28 Sep 2014
| 9 comments
,
|
![]() |
I have created below table:
03 Sep 2014
| 1 comment
,
|
![]() |
Hi All,
11 Jul 2014
| 7 comments
,
|
![]() |
As volatile table definition does not go into DD, how Indexes and stats works on volatile table?
12 Jun 2014
| 1 comment
,
|
![]() |
Hi All,
04 Jun 2014
| 3 comments
,
|
![]() |
Hello,
15 Oct 2013
| 5 comments
,
|
![]() |
Hi Teradatares :-)
06 Oct 2013
| 5 comments
,
|
![]() |
Hi All,
24 Aug 2013
| 5 comments
,
|
![]() |
Hi All,
16 Aug 2013
| 4 comments
,
|
![]() |
This session provides information on the basic concepts of Partitioned Primary Indexes.
25 Feb 2013
| 12 comments
,
|
![]() |
05 Nov 2012
,
|
![]() |
Is it a good practice to define a Primary Index on VARCHAR column ? Although I dont see any strange (data type conversions) in explain plans between Join operations on VARCHAR (Primary Index) to CHAR column (Primary Index) since they are from same domain, I just want to understand if this is as efficient as Joins between CHAR to CHAR columns.
17 May 2011
| 6 comments
,
|
![]() |
I have noticed that while creating a table, I can create Primary Keys using the following syntax : CONSTRAINT name PRIMARY KEY (column1, column2....) However if I pull up the SQL for table creation after the initial create, this becomes UNIQUE PRIMARY INDEX name (column1, column2...)
14 Apr 2011
| 2 comments
,
|
![]() |
This is more than an overview of the Indexes that are available in Teradata and how they work.
06 Apr 2011
| 3 comments
,
|
![]() |
Hi, How can I query for all the Primary Indexes that doesn't have statistics collected? (for all tables of all databases). Thanks in advance, Regards
17 Nov 2010
| 5 comments
,
|
![]() |
Hi All, I am a beginner on Teradata and am involved in an exploration to figure out what it would take to migrate an existing system based on Informatica PC+Oracle to Informatica PC+Teradata. I am trying to understand some guidelines or best practices in determining primary index for tables - I understand this is an optimization exercise to maximize data distribution while trying to use fewer columns, using those that are used for querying often are recommended.
29 Sep 2010
| 1 comment
,
|
![]() |
The purpose of the new Teradata 13.0 feature that allows you to create tables with no primary index is improved performance of FastLoad and Teradata Parallel Data Pump Array INSERT data loading operations.
09 Apr 2009
| 13 comments
,
|