#DateForumTypeThreadPost
7529 Jun 2015 @ 11:17 PDTDatabaseTopicCurious case with optimiser explain select   a.column1               a.column2               a.column3         ...
7424 Apr 2015 @ 11:41 PDTDatabaseReplyDynamic partition eliminationDynamic 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...
7321 Jan 2015 @ 04:38 PSTDatabaseReplyHow to decide about Stats for new queriesStats 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...
7201 Jul 2013 @ 04:02 PDTConnectivityTopicSeeking 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...
7106 Jun 2013 @ 11:04 PDTData ModelingReplySecurity views in Semantic data modelling.Thanks Lee Which TD version have these capablitites? I know it was missing till TD 12.
7017 Aug 2012 @ 11:37 PDTDatabaseReplyAdding 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...
6930 Apr 2012 @ 06:44 PDTDatabaseTopicINSERT 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...
6827 Mar 2012 @ 01:56 PDTDatabaseReplyhow to get this complex TIMESTAMP output ? thank you Dieter....this works.. with my SQLs I was getting invalid timestamp error while using CAST.
6726 Mar 2012 @ 10:19 PDTDatabaseTopichow 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  ...
6606 Jan 2012 @ 11:32 PSTGeneralReplyTeradata 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...
6506 Jan 2012 @ 10:35 PSTDatabaseReplyUsing store procedure in SQL. Is it possible ? thanks Dieter... is this facility available in any other DBMS ? 
6405 Jan 2012 @ 04:05 PSTDatabaseTopicUsing 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 !!
6316 Nov 2011 @ 05:03 PSTGeneralReplyTPT over other Load Utilities How about limits or disadvantages ? Can anyone list any limitations compared to fload/mload ?
6214 Nov 2011 @ 10:12 PSTPrivate Forum
6130 Oct 2011 @ 12:29 PDTDatabaseReplyMystery 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...
6025 Oct 2011 @ 04:15 PDTDatabaseTopicMystery 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 ...
5928 Sep 2011 @ 02:11 PDTDatabaseReplyTeradata 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...
5821 Sep 2011 @ 04:46 PDTDatabaseReplyAny 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...
5719 Sep 2011 @ 11:42 PDTDatabaseReplyCopying 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...
5619 Sep 2011 @ 10:42 PDTDatabaseReplyHow 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...
5526 Aug 2011 @ 11:47 PDTDatabaseReplyIs 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.
5417 Aug 2011 @ 02:28 PDTDatabaseTopicquery logging on batch idswhat 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...
5311 Jul 2011 @ 02:37 PDTDatabaseTopicquery to find a database used in views, macros ,SP etcHi 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 ?
5225 May 2011 @ 12:21 PDTDatabaseReplyis 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
5112 Mar 2011 @ 03:38 PSTDatabaseTopicQuestion for Profiles attributeIn 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 ...

Pages