IBM Mainframe Forum

My SQL is not performing well. Describe how will you fine tune it?

How high is up?

I would ask on a forum of psychic and pray to any diety available.

sinmani wrote:My SQL is not performing well. Describe how will you fine tune it?

For Rs. 50,000/day

well guys stop kicking my **

What I think is i should use explain option and then look into plan table to get the current call path DB2 is using and then try to change it.
But how exactly would that help me?
What rows I should look into plan table?

How can I do I know which path will be better and ensure that DB2 uses it?

Talk to your colleagues, DBA,,,,

sinmani, in your second post you are wanting to know the process to identify performance issues in an SQL statement; in your first post you did not clearly identify that this is what you were looking for. Your first post basically said you have an SQL statement that is having performance issues and you want help in fixing it -- without identifying (1) whether or not there really is a performance issue (if you're reading a data base with 10 million rows, then I'm sorry but the computer is going to take a while to read them), or (2) what is the SQL statement, or (3) why we would WANT to fine tune it?