Performance monitor
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Performance monitor Expand / Collapse
Author
Message
Posted 8/11/2009 10:39:54 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 11/1/2009 1:22:16 PM
Posts: 15, Visits: 77
Hi all,

How can we improve performance of a query by seeing performance monitor tool.

Thanks,
kiran
Post #16497
Posted 8/21/2009 3:45:08 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34, Visits: 117
YOu can not able to increase the performance of a query from PMON. But obviously by looking at the execution plan - you can tune your query. Check the CPU usage, Skew Factor et. al.
Also you can increase the priority to get finished quickly.
Post #16625
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 9:51am

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.094. 9 queries. Compression Disabled.