InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 10:19:59 GMT20http://www.teradata.com/teradataforum/Topic15932-10-1.aspxcan some one point me the right URL for Teradata @ Your Service?so that i can download this Orange BookWed, 15 Jul 2009 04:33:29 GMTstandalonehttp://www.teradata.com/teradataforum/Topic15932-10-1.aspxcan any body tell me how PPIs will help in performance?Sun, 12 Jul 2009 12:26:31 GMTgrimm336http://www.teradata.com/teradataforum/Topic15932-10-1.aspxThis is a huge topic that cannot be answered quickly. There are several Orange Books and Teradata classes that will help. Some of the Orange Books include topics on indexes (PPI and non-PPI), Tuning Tactical Queries, and many others. Orange Books can be downloaded from Teradata @ Your Service (contact your site administrator or DBA if you don't have access to T@YS). To tune queries, you need a solid understanding of the basics, including primary and secondary indexes (how to choose and how to use), database/table design, statistics, and joining tables. Spend a lot of time in the Teradata documentation (your DBA or site administrator should be able to help you install this on your computer). I don't have my list of classes that Teradata offers, but there are several that will help to gain enough understanding to tune queries. Last, but not least, use EXPLAIN to see how your queries will be run. Good luck!Mon, 06 Jul 2009 17:30:44 GMTCliffhttp://www.teradata.com/teradataforum/Topic15932-10-1.aspxI am also new to Teradata, but not performance management in general.Can you elaborate on what you are looking to tune? You could tune queries, which would involve looking at the access paths, data distrubution, Primary Keys and Primary indexes etcyou could look at tuning the System in general, Memory allocations CPU, number of Amps/PE et al.There does not seem to be the wealth of information on the internet about Teradata, that does not originate from Teradata, as you would find with Oracle or DB2, and there are only a few books on Teradata on Amazon etc which are old.I found the following books on Teradatas site to be helpful.Resource Usage Macros and Tables.Teradata RDBMS Performance OptimizationPerformance management.They gave me a good start, but I may have been starting from a different position. Tue, 30 Jun 2009 05:46:06 GMTRandom_thoughthttp://www.teradata.com/teradataforum/Topic15932-10-1.aspxHi ,Which tool we can use to do performance tuning in Teradata.As PMON is used to just view the query and to check the status of that query.Regards,kiranFri, 26 Jun 2009 15:43:57 GMTkiran parsha