#DateForumTypeThreadPost
2519 Aug 2013 @ 03:20 PDTViewpointReplySQL and Explain sometimes not visible in query monitorAfter changeing Monitor Rates & Data Collectors > Sessions , Restart you viewpoint server . You will see SQL and Explain in query monitor
2410 Apr 2013 @ 03:21 PDTPrivate Forum
2318 Jul 2012 @ 11:37 PDTPrivate Forum
2212 Apr 2012 @ 12:42 PDTPrivate Forum
2112 Apr 2012 @ 11:51 PDTPrivate Forum
2001 Feb 2012 @ 06:06 PSTPrivate Forum
1918 Jan 2012 @ 09:06 PSTPrivate Forum
1810 Jan 2012 @ 08:52 PSTPrivate Forum
1718 Sep 2008 @ 05:51 PDTDatabaseReplyCOLLECT STATS on combination of columns than single columnHudson & Dieter ,Thanks for you Inputs.I Ran diagnostic helpstats on session : I got recommendation 1What is the main diff between recommendation 1 & recommendation 2, If we collect STATS recommen...
1617 Sep 2008 @ 04:57 PDTDatabaseTopicCOLLECT STATS on combination of columns than single columnHi ,Need recommendation for collecting stats TB1.COL1 = TAB2.COL1ANDTB1.COL2 = TAB2.COL2Recommendation 1: COLLECT STATS TB1 COLUMN (COL1,COL2);COLLECT STATS TB2 COLUMN (COL1,COL2)Recommendation 2:C...
1520 Aug 2008 @ 01:09 PDTDatabaseReplyCPU and IO USAGE.
1420 Aug 2008 @ 01:04 PDTDatabaseReplyUrgent : join between primary index and secondary index.
1320 Aug 2008 @ 01:04 PDTDatabaseReplyUrgent : recommendation for partitionsThanks
1207 Aug 2008 @ 05:49 PDTDatabaseReplyUrgent : join between primary index and secondary indexWhat are the pros and cons if we join between primary index and secondary index Example:-Table_1Primary index( t1,t2)Secondary index ( t3,t4,t5,t6)Table_2Primary index(t1,t2)JoinTable_1.t4 = Table_...
1107 Aug 2008 @ 02:12 PDTDatabaseTopicUrgent : join between primary index and secondary indexWhat are the pros and cons if we join between primary index and secondary index Example:-Table_1Primary index( t1,t2)Secondary index ( t3,t4,t5,t6)Table_2Primary index(t1,t2)JoinTable_1.t4 = Table_...
1005 Aug 2008 @ 10:48 PDTDatabaseReplyUrgent : recommendation for partitionsRelation is 1:MThere is no UPI only PIThanks for your responseRegards,Mahesh
925 Jul 2008 @ 04:47 PDTDatabaseTopicUrgent : recommendation for partitionsHi Experts,I need recommendation for following partitions 1) PRIMARY INDEX TABLE1 ( P_KEY )PARTITION BY RANGE_N(P_YYMM_DT BETWEEN 1001 AND 1002 EACH 1 ,1011 AND 1012 EACH 1 ,1021 AND 1022 EA...
824 Jul 2008 @ 08:13 PDTDatabaseTopicIMP : New EXPLAIN TerminologyHi Experts,I run explain plan .I encounter below new EXPLAIN terminology *** are left outer joined using a rowkey-based sliding-window merge join (contexts = 1, 31),with a join condition of ****...
724 Jul 2008 @ 08:11 PDTDatabaseTopicNew EXPLAIN TerminologyHi Experts,I run explain plan .I encounter below new EXPLAIN terminology Please tell/ explain me above Thanks in advanceRegards,Mahesh.
616 Jul 2008 @ 06:23 PDTDatabaseTopicCPU and IO USAGEHi Experts,What are major consideration/ recommendation we need to consider if there are more CPU and IO USAGE? For exampleCPU IO CPU skw IO skw17600 822800 2.07 14.922175 2060890 10.7 56.54266.06...
511 Jul 2008 @ 01:27 PDTDatabaseTopicChar to DateHello experts,I need help for converting Char date format to date I need to convert CHAR FORMAT '11-JULY-2008' TO DATE FORMAT 2008-07-11 CHAR FORMAT '11-MAY-2008' TO DATE FO...
418 Mar 2007 @ 11:45 PDTDatabaseTopicDifferent between soft referential integrity and hard referential integrityHi Friends ,I need help regarding ….What is different between soft referential integrity and hard referential integrity with example and how it will affect loading RECORDS into Teradata DB?Thanks...
329 Aug 2006 @ 07:02 PDTDatabaseTopicConfiguring a Teradata Relational Database Connection for informatica(Informatica Workflow Monitor)Hi Experts,I am trying to extract data from Teradata and load into Oracle using Informatica. I am facing problem in Configuring a Teradata Relational Database Connection for Informatica (Informatic...
207 Jun 2006 @ 06:05 PDTDatabaseReplyQuestion Regarding from sub tables?Thanks for your reply.You mean that.. There is no way to retrieve data from sub tables-Best Regards,Mahesh Godi.
106 Jun 2006 @ 07:12 PDTDatabaseTopicQuestion Regarding from sub tables?Can any body know how to see or retrieve data from sub tables? Regards,Mahesh