75 | 29 Jun 2015 @ 11:17 PDT | Database | Topic | Curious case with optimiser explain |
select a.column1
a.column2
a.column3
... |
74 | 24 Apr 2015 @ 11:41 PDT | Database | Reply | Dynamic partition elimination | Dynamic row partition elimination improves performance when a partitioned table and a non partition table are joined by an equality condition on the partitioning column set of the partitioned table... |
73 | 21 Jan 2015 @ 04:38 PST | Database | Reply | How to decide about Stats for new queries | Stats collection is an ever refining process. Don't get too much overwhelmed about it. Run the queries , do stats , run them again and keep on adding /removing following the basic guidelines an... |
72 | 01 Jul 2013 @ 04:02 PDT | Connectivity | Topic | Seeking information on Teradata database compatibility with JRE |
We are using Teradata database 12 as our production database and as part of policy we are required to see if we can upgrade JRE to 1.7
I have seen prior posts for Teradata database compati... |
71 | 06 Jun 2013 @ 11:04 PDT | Data Modeling | Reply | Security views in Semantic data modelling. | Thanks Lee
Which TD version have these capablitites? I know it was missing till TD 12.
|
70 | 17 Aug 2012 @ 11:37 PDT | Database | Reply | Adding Compression to existing table |
It works with TD 12.00 also.
Here's a testing script..
--Adding compression on existing column
----------------------------------------
SEL * FROM DBC.D... |
69 | 30 Apr 2012 @ 06:44 PDT | Database | Topic | INSERT SELECT Performance mystery |
I'm creating a empty table TARGET_TABLE from an existing populated table SOURCE_TABLE using
CREATE TABLE TARGET_TABLE AS SOURCE_TABLE WITH NO DATA
and doing a IN... |
68 | 27 Mar 2012 @ 01:56 PDT | Database | Reply | how to get this complex TIMESTAMP output ? |
thank you Dieter....this works.. with my SQLs I was getting invalid timestamp error while using CAST.
|
67 | 26 Mar 2012 @ 10:19 PDT | Database | Topic | how to get this complex TIMESTAMP output ? |
A source table have following columns
POST_DATE VARCHAR(8)
POST_TIME INTEGER
and these columns contains DATE and TIME values..such as
 ... |
66 | 06 Jan 2012 @ 11:32 PST | General | Reply | Teradata Password Policy |
you need to either modify values under table dbc.syssecdefaults (and a possible system restart to push the changes) or if the users have profiles defined then you need to modify profile. Ei... |
65 | 06 Jan 2012 @ 10:35 PST | Database | Reply | Using store procedure in SQL. Is it possible ? |
thanks Dieter...
is this facility available in any other DBMS ?
|
64 | 05 Jan 2012 @ 04:05 PST | Database | Topic | Using store procedure in SQL. Is it possible ? |
Haven't seen such a scenerio and would like to know if its pooisble to use store prcedure in a SQL statement?
Please share any insight !!
|
63 | 16 Nov 2011 @ 05:03 PST | General | Reply | TPT over other Load Utilities |
How about limits or disadvantages ?
Can anyone list any limitations compared to fload/mload ?
|
62 | 14 Nov 2011 @ 10:12 PST | Private Forum |
61 | 30 Oct 2011 @ 12:29 PDT | Database | Reply | Mystery around trailing space |
Yes..Thanks Carlos..that helps...
I dig further and heres my finding:
Teradata follows the ANSI standard on how to compare strings with spaces. The ANSI standard requires padding for the... |
60 | 25 Oct 2011 @ 04:15 PDT | Database | Topic | Mystery around trailing space |
On running below queries ,why i'm getting the same result despite the fact that the 2nd query is having trailing spaces:
1st query with no leading or trailing space
... |
59 | 28 Sep 2011 @ 02:11 PDT | Database | Reply | Teradata IN List allowable limit |
Check for the possiblity of feeding values using subquery.There should be performance gain on using subquery, if your IN clause have more than 50 values.
The mentioned error is 3710 error co... |
58 | 21 Sep 2011 @ 04:46 PDT | Database | Reply | Any advice to increase efficiency of my query? |
Query looks ok. Few of the basic performace checks can be:
1.Stats should be up to data for joining columns and WHERE clause columns.
2.Joining column should share same data t... |
57 | 19 Sep 2011 @ 11:42 PDT | Database | Reply | Copying the data from another table wth diffrent timestamp |
Here's the solution...
Dirent CASTing of TIMESTAMP(6) to TIMESTAMP(0) won't be possible. Therefore, use CAST to convert it into character and substring to chop unwanted part an... |
56 | 19 Sep 2011 @ 10:42 PDT | Database | Reply | How to get all the dbc.% tables in Teradata |
SELECT TABLENAME FROM DBC.TABLES WHERE DATABASENAME = 'DBC' AND TABLEKIND = 'T' ;
Run above command to list all DBC tables.
You should have read access on view DBC.TABLES... |
55 | 26 Aug 2011 @ 11:47 PDT | Database | Reply | Is there a "reserved words" table/view? |
If you refer to Teradata documentation- SQL Fundamental then there is Appendix B: Restricted Words. Another document is Release Summary for a given release.
|
54 | 17 Aug 2011 @ 02:28 PDT | Database | Topic | query logging on batch ids | what should be the ideal query logging on nightly ETL batch ids?
I recommend to capture only those batch queries (with SQL) consuming more than 1000 CPU secs :
BEGIN QUERY LOGGING LIMIT THRESH... |
53 | 11 Jul 2011 @ 02:37 PDT | Database | Topic | query to find a database used in views, macros ,SP etc | Hi fellow members
Can anyone help in sharing ideas,hints or precise query to find the list of all views (or macro,SP) who are using a particular database in its code ? |
52 | 25 May 2011 @ 12:21 PDT | Database | Reply | is there another tool to kill sessions instead Teradata Manager? | go thru this...
http://forums.teradata.com/forum/database/how-to-abort-session-without-pemon-or-tdmanager#comment-13015 |
51 | 12 Mar 2011 @ 03:38 PST | Database | Topic | Question for Profiles attribute | In Teradata 12,I want to change password usability setting so that user can re use the same password after it gets expire. For that I executed below SQL:
MODIFY PROFILE ANALYTICAL_BATCH_PROFILE ... |