|
A Question from our Quest SQL Optimizer User |
|
RichardTo
|
Thursday, September 04, 2008 1:50 AM
|
|
|
Recently, we got a question from a customer:
“Why does adding a ||'' to the end of a key value improve performance... in this case significantly, this query runs in 187 milliseconds regularly where without the ||'' it takes minutes to run... This is the only modification in the result set from SQ ...
|
 |
|
Comments (2)
|
Read More...
|
|
|
Getting Risk Right – How Probable is Your Probability? |
|
JohnWeathington
|
Thursday, September 04, 2008
|
|
|
|
Inaccurate risk probabilities can wreak havoc on the applicability of your risk database. Why go through the trouble of setting it up, if bad probability entries render your database unusable? In this article, we explore the importance of getting the risk probability correct, and ways to improve your accuracy.
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Automated Maintenance |
|
JimWankowski
|
Wednesday, September 03, 2008 7:31 AM
|
|
|
Automated maintenance began with DB2 LUW 8.2. At this time the behavior of automated utilities had to be controlled manually either through the Control Center or the automation wizard. Now with DB2 9.5 automation of RUNSTATS and REORG commands can be controlled by an XML document referred to as an “automatic maintenance policy” These policies control which objects are consi ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
What’s Coming in Toad 9.7 - Part 2 |
|
JohnPocknell
|
Friday, August 29, 2008 6:56 AM
|
|
|
|
It’s almost that time again as another exciting new release of Toad draws closer! We’ve decided that, rather than let you wait until Toad 9.7 is released before you see what’s new, we’ll give you a little fore-taste now! In this final blog (
|
|
Comments (0)
|
Read More...
|
|
|
Beyond Compliance – Understanding Risk |
|
JohnWeathington
|
Thursday, August 28, 2008
|
|
|
|
Compliance usually starts with a fire drill, however intelligent companies take the time to step back and put their compliance into perspective. Risk is the key to understanding and optimizing your compliance program. In this article, we discuss risk as an evolution from compliance, and look at some ways to model it in the enterprise.
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
What’s Coming in Toad 9.7 - Part 1 |
|
JohnPocknell
|
Friday, August 22, 2008 8:56 AM
|
|
|
|
It’s almost that time again as another exciting new release of Toad draws closer !
We’ve decided that, rather than let you wait until Toad 9.7 is released before you see what’s new, we’ll give you a little preview now !
The main objectives of this release are to provide improved knowledge and e ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Who’s on First? How to Model Accountability |
|
JohnWeathington
|
Thursday, August 14, 2008
|
|
|
|
A consistent pattern that emerges in compliance best practices, is the notion of accountability. Demonstrating accountability is a key component of building a solid compliance program. In this article, we explore the motivation, requirement, model, and architecture to make accountability a reality in your company.
|
|
|
|
Comments (0)
|
Read More...
|
|
|