We help IT Professionals succeed at work.

Query optimization & indexing

k_murli_krishna
on
436 Views
Last Modified: 2006-11-17
1) We have Db2 7.2 on windows NT/2000, AIX & mainframes.

2) I would like tools, inbuilt/3rd party which can help me in optimizing queries and generating indexes.

3) Also give links that help me or mail documents to k_murli_krishna_2000@yahoo.com.
 
Comment
Watch Question

Author

Commented:
For point 3, what I mean is query & index tuning by self.
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
yup, thats a good link, always interesting to see how people spend their free time. While this gui tool duplicates all the built in functionality of DB2 and is undoubtlably a great effort on the part of the programmer, the user still needs to understand how to use it and how to intepret the results. But it certainly does make snapshot monitoring easier to use.

Commented:
exception: it doesnt do lock monitoring, either on EE or EEE database.

Author

Commented:
Thank you very much. I am increasing points to 200 and splitting them.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.