4730 Nov 2015 @ 02:02 PSTDatabaseReplyNodes TypesSWS and App Node are same?
4627 Nov 2015 @ 11:53 PSTDatabaseReplyNodes TypesWhat are application node and SWS node?
4530 Oct 2015 @ 06:58 PDTDatabaseReplyDrop DatabasesThanks a lot!
4430 Oct 2015 @ 06:55 PDTDatabaseReplyNodes TypesCould you please elaborate the purpose of having them?Do we need to have them?
4329 Oct 2015 @ 01:10 PDTDatabaseTopicDrop DatabasesHello ! We need to drop few databases. Can we drop database even if it has tables? Same with tables, can we drop tables having data?   Whats the best approach to do this?   Thanks !
4227 Oct 2015 @ 02:14 PDTDatabaseTopicTD Certification 12Wondering if one can take test for TD certification still? Or its just TD14 certification path is available?     Thanks!
4127 Oct 2015 @ 02:09 PDTDatabaseTopicNodes TypesCan somebody explain AMPless Node, PE only Node, FiCon node?   What is their purpose and how they affect overall capacity of TD?
4023 Jan 2015 @ 03:02 PSTDatabaseReplyHow to decide about Stats for new queriesHow one can check If the stats on one or more cols were not used in the query ?
3905 Dec 2014 @ 02:25 PSTDatabaseReplyAcctg vs DBQL vs ResUsageIts like... Acctg - captures CPU & IO data on AccountString/UserID level. Same data can be found in DBQL also but difference being  Accounting data tend to be more correct as DBQL doesn&r...
3805 Dec 2014 @ 11:11 PSTDatabaseReplyHow to decide about Stats for new queriesThanks !! How i can check which stats are being used for the query? :-) Sorry not expert in Teradata     What would be the impact of keeping the stats which are not being used?
3703 Dec 2014 @ 01:01 PSTDatabaseReplyNodes and AMPs for Query TuningIs it okay to assume, if query is okay in lower number of nodes/AMPs, it will perform better in system with higher number of nodes/AMPs? All other parameters are same.
3603 Dec 2014 @ 11:15 PSTDatabaseReplyCollecting Query MetricsThanks !   Any suggestions how to avoid non equality condition in the join condition like  '>=' , '<=' etc
3502 Dec 2014 @ 04:27 PSTDatabaseReplyExplain Plan - Final & Other PlanWhat is indicated when difference between Estimated time/Rows and actual time/Rows?   Also, how does it matter if Actuals are lower or higher? What they indicate?
3402 Dec 2014 @ 03:21 PSTDatabaseReplyHow to decide about Stats for new queriesFrom those recommendations, Only with High confidence should be collected?
3302 Dec 2014 @ 03:17 PSTDatabaseReplyCollecting Query MetricsThanks Dieter for the valueable info !   Though i can see some keywords showing bad indicators, but really having hard time to narrow down to where in query to fix.. For Ex: i see a product...
3202 Dec 2014 @ 12:34 PSTDatabaseReplyTeradata 14 certification HelpTry amazon TD 14 certification books (for just certification study) along with TD manuals (for detailed study)
3102 Dec 2014 @ 11:08 PSTDatabaseReplyHow to decide about Stats for new queriesFor any new query on new table when no prior stats collected... - Wil Running Diagnostic Helpstats give all the stats needed for the query?   I mean rather looking in joins/where clause of...
3002 Dec 2014 @ 11:04 PSTDatabaseReplyExplain Plan - Final & Other PlanThanks Dieter.   Should we use stats recomendations provided under both plans?    
2902 Dec 2014 @ 11:04 PSTDatabaseReplyCollecting Query MetricsDBQL details can be collected only after running the query. Right? I don't think there is way to get the same w/t running the query. Possible?
2802 Dec 2014 @ 11:01 PSTDatabaseReplyNodes and AMPs for Query TuningSo, if test & Prod systems have different no. of nodes & amps...what is best way to tune queries? I mean, first tuning efforts in test & again in prod OR it doesn't matter. Please ...
2702 Dec 2014 @ 10:58 PSTDatabaseReplyUser Spool LimitThanks Samir. Thats surely a good way to start.   Any other inputs welcome...
2601 Dec 2014 @ 06:40 PSTDatabaseTopicCollecting Query MetricsHello !   In order to tune queries, What metrics can be collected from Explain Plan Vs metrics can be collected only after running the query (from DBQL).   In other words, what quer...
2501 Dec 2014 @ 03:06 PSTDatabaseTopicExplain Plan - Final & Other PlanHi All ! I usually see this in o/p of Diagnostic Helpstats: <- END RECOMMENDED STATS FOR FINAL PLAN BEGIN RECOMMENDED STATS FOR OTHER PLANS ->   So, what are Final & Other Plans...
2401 Dec 2014 @ 02:58 PSTDatabaseTopicUser Spool LimitHello !   How to check/decide about correct Spool limit one user should have?   Thanks
2301 Dec 2014 @ 02:45 PSTDatabaseTopicNodes and AMPs for Query TuningHello All !   Wondering how Nodes & no. of AMPs effect the run of a query?  For ex: if Non Prod Env has 10 Nodes but Prod env has 40 nodes. How it'll effect the same query in ...