with Tags:
sql
X
X
Setting options for the tuning advisors
Each of the tuning advisors in IBM Data Studio, IBM InfoSphere Optim Query Tuner, and IBM InfoSphere Optim Query Workload Tuner has at least one option that you can set to influence the recommendations that they generate. Some of the advisors have exactly one option, but the advisors that help with statistics and indexes have many more than that. In this blog, I'd like to explain some of these options from time to time because a number of them look complicated, are not documented well, or both.
The options appear in two places. In one... [More]
Tags: tuning advisors sql |
Tuning SQL statements that contain variables when you are developing SQL routines
Here's a handy tip for a Monday. You might already know that, in InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner, you can use the client to develop SQL stored procedures. When you are working in a routine editor, you can right-click anywhere in an SQL statement and select Start Tuning to open the Query Tuner workflow assistant. The statement appears in the Query Tuner workflow assistant. From this location, you can run advisors and tools to get analyses and recommendations.
Until version 3.1, if the SQL statement... [More]
Tags: performance sql routines tuning |
General steps for tuning SQL
Have you ever noticed that you can't do anything that someone else hasn't declared to be an art? To use a now commonplace method of generating examples, go to Google and search on the words "art of". To list only those on the first page of results that I get: art of manliness art of trolling art of participation art of questioning art of living art of shaving art of flight art of dying art of seduction art of the steal art of marriage art of getting by These are dubious arts, at best. If shaving is an art, then it's most likely a... [More]
Tags: tuning sql performance |
Information roadmap for InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner
Using software can be like trying to get to a freeway onramp that you know well by driving through an unfamiliar part of a city. You know what the outcome should look like (cruising on the open highway), but to get there you have to learn new landmarks ("Ah, so I turn left at the donut shop!"), new shortcuts ("So, I saved 5 minutes by taking Jefferson. I'll have to remember that."), the streets that go only one way (*pant, pant* "No, I guess I can't drive that way down Sycamore after all."), and more. The... [More]
Tags: sql tuning roadmap performance documentation |
