Are access plans and "timerons" comparable from one DB2 Server to another or are they dependent on the server they are run on. I am trying to compare access plans for the same piece of sql code run on two different servers each containing a copy of the same database and data. sane environment different physical servers.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Timerons - are the comparable across servers ?
- Thread starter JFK40
- Start date
Timerons are pretty much useless imho. If you want to performance a piece of sql, do this:-
1. Do a "runstats" on all the tables in the sql.
2. Run dynamic explain and look for:-
a) Table scans
b) Nested loop joins to tables with a lot of rows in them
c) Inefficient indexes e.g. where it's only using 1 of the index columns.
3. Once you've appropriately indexed the sql, if it's still a problem then start splitting down the sql and actually running each bit to find which section is causing you problems.
1. Do a "runstats" on all the tables in the sql.
2. Run dynamic explain and look for:-
a) Table scans
b) Nested loop joins to tables with a lot of rows in them
c) Inefficient indexes e.g. where it's only using 1 of the index columns.
3. Once you've appropriately indexed the sql, if it's still a problem then start splitting down the sql and actually running each bit to find which section is causing you problems.
- Status
Similar threads
- Locked
- Question
- Locked
- Question