#DateForumTypeThreadPost
1720 Oct 2007 @ 03:57 PDTDatabaseReplyproblem with derived tableYes. It is pretty difficult to give inputs on this without knowing the actual Query structure.(for instance you havent mentioned the joining conditions and from which table a1 is coming in each of ...
1615 Oct 2007 @ 07:50 PDTDatabaseReplySize of partitions and PPI performanceCollecting statistics on the System column PARTITION(An ID/Number which identifies a Partition) will help the optimiser in coming up with a better plan when the read table has partitions.If a parti...
1515 Oct 2007 @ 01:54 PDTDatabaseReplySize of partitions and PPI performanceIf there are too many partitions and most of them dont have data, your performance would suffer.But since you have used partitioning, why dont you use the new V2R6 feature of collecting stats on th...
1415 Oct 2007 @ 01:39 PDTDatabaseReplyHow to find the no of nodes in my teradata system using sql assistant?You can get the total number of AMPs in the system from the following query if you have access to AmpUsage view!!!Select Count( distinct vproc) from dbc.AmpUsageBut to get the No of Amps per node y...
1312 Oct 2007 @ 01:58 PDTDatabaseReplyHow to find the no of nodes in my teradata system using sql assistant?Try out this query for no of NodesSelect count(distinct nodeid) from dbc.resusagescpuAnd this one for number of Amps per nodeSelect nodeid,count(distinct Vproc) from dbc.ResCpuUsageByAmpViewHope th...
1206 Oct 2007 @ 01:04 PDTDatabaseReply[HELP] How to collect statistics...Yes. Dieters option would work out.If a partition is empty it would be left out from the read process even if its not eliminated directly by the query.But this facility is available only from V2R6 ...
1103 Oct 2007 @ 01:19 PDTDatabaseTopicDoubts On Compression Related Calculations!!!Hi, I have the following 2 doubts on compression related calculations (Reference : Database Design Document, Section : Database Level Capacity Planning Considerations --> Calculating the efficienc...
1003 Oct 2007 @ 12:31 PDTDatabaseReplyTeradata Orange Books!!!Hi Leo,Thanks for the info!!!
928 Sep 2007 @ 05:08 PDTDatabaseReplyTeradata Orange Books!!!Hi Leo,Thanks for the information!!!Kindly let me know what Teradata exactly means by a "Site ID".Assume i have a problem with my Teradata Installation, now what information should i be giving for ...
827 Sep 2007 @ 05:46 PDTDatabaseTopicImpact of Renaming a Table !!!Hi,Assume i had Table A with indexes and stats collected on it.Now i create Table B with complete data from Table A (except that i introduce compression in few columns) then rename Table A to Table...
727 Sep 2007 @ 01:55 PDTDatabaseTopicTeradata Orange Books!!!Hi,Kindly let me know how to access the Teradata Orange Books.When i try to access the orange books at Teradata.com it prompts me to apply for"Teradata@ your service" membership.But in the applicat...
626 Sep 2007 @ 02:58 PDTDatabaseReplySecondary Index causes query to peform poorly.You havent mentioned if its USI or NUSI.USI is always a two AMP operation and in most cases it would be more efficient to access records via USI.The same is not true with NUSI.Sometimes not having ...
526 Sep 2007 @ 02:46 PDTDatabaseReplyRegarding Row Alignment on Even Bytes!!Hi Jim,Thanks for explaining it clearly!!!!
420 Sep 2007 @ 01:24 PDTDatabaseTopicRegarding Row Alignment on Even Bytes!!Hi,It has been mentioned in the Database Design PDF that Rows are always assigned on even bytes.The reason given was that there will be a performance penalty when rows are not aligned.Can someone e...
313 Sep 2007 @ 04:04 PDTDatabaseTopicFallback & Down Amp recovery journal!!!Hi,When a Fallback protected AMP goes down during a write operation, the update takes placein the Fallback AMP in the same cluster to later update in the original AMP when it recovers.When an AMP g...
210 Sep 2007 @ 03:24 PDTDatabaseReplyJoin IndexHi Joe,Can you please explain a bit more on what you mean by the following comment of yours."One of the critical working intrinsics of both Multi Load and Fast load are that they are AMP local. "I'...
130 Aug 2007 @ 02:30 PDTDatabaseTopicAre Teradata Demo CDs shipped to users across the globe?Hi,I'm based in india and would like to work on the Teradata Tools and utilities like Teradata manager and analyst Pack which are available in the Demo CD.I would like to know if Teradata Demo cds ...

Pages