|
|
The importance of SQL scalability testing |
|
JimWankowski
|
Thursday, August 30, 2007 1:26 PM
|
|
|
|
As we all know, there are many factors that influence the performance of your application. Proper memory allocations, physical design, how the SQL is written and workload all affect the way your queries perform. One of most overlooked parts of testing an application is testing queries under production workload conditions.< ...
|
 |
|
Comments (2)
|
Read More...
|
|
|
Quseful #7: Kill those infinite loops! |
|
StevenFeuersteinTW
|
Wednesday, August 29, 2007 12:42 PM
|
|
|
|
I don't know about you, but I sometimes write code that (inadvertently, not on purpose) contains an infinite loop. So I run my program and Toad goes off into never-never land, with Oracle chewing up CPU cycles so intently that it is hard to connect as SYS and kill the session.
...
|
|
|
|
Comments (2)
|
Read More...
|
|
|
Oracle 11g Introduces Invisible Indexes |
|
Bert
|
Monday, August 27, 2007 6:09 AM
|
|
|
|
As I wrote last week, Oracle 11g has a plethora of really great new features. One that should really hit a home run with data warehousing DBAs is “Invisible Indexes.” The name is not a joke – they are exactly what they say. An invisible index is ignored by the query optimizer when forming an explain plan for a SELECT statement, ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
|
Oracle 11g Improves Partitioning |
|
Bert
|
Tuesday, August 21, 2007 4:21 AM
|
|
|
|
Oracle 11g has a plethora of great new features. One area that has improved with each of the last four releases has been partitioning, i.e. the method to break larger tables into smaller, more manageable and efficient sub-tables. While it was originally touted as a boon for just the data warehousing world, partitioning no ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Quseful #6: Generate collections of random values |
|
StevenFeuersteinTW
|
Friday, August 17, 2007 9:27 AM
|
|
|
|
You will find in this Quseful a package that will generate/return collections of random values of strings, numbers and dates. It also contains a "self-test" random_verifier procedure that you can run to verify "at a glance" that the values being generated seem
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Welcome to the Toad for DB2 blog |
|
JimWankowski
|
Wednesday, August 15, 2007 10:41 AM
|
|
|
|
Welcome to my inaugural blog for Toad® for DB2. Many of you may not be aware that Toad is now a multiplatform solution. I plan to discuss subjects across both DB2 running on the LUW platf ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Oracle 11g Adds Virtual Columns & Indexes |
|
Bert
|
Wednesday, August 15, 2007 6:18 AM
|
|
|
|
Oracle 11g is out for Linux – and like every new release, there’s tons of cool new stuff. So over the next few weeks, I will write about some of Oracle 11g’s new features. This week, I’ll look at Virtual Columns and Virtual Indexes.
|
|
Comments (3)
|
Read More...
|
|