Teradata Optimization and Performance Tuning

What is optimization and performance tuning and How does it work in practical projects. Explain with an example.

Questions by prvn456

Showing Answers 1 - 3 of 3 Answers

asshu18

  • Apr 14th, 2009
 

Optimization is the technique of selecting the least expensive plan (fastest plan) for the query to fetch results.
Optimization is directly proportional to the availibility of --
1. CPU resources
2. Systems resources - amps, PEs etc.

=============================================================

Teradata performance tuning is a technique of improving the process in order for query to perform faster with the minimal use of CPU resources.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions