Re: SQL Optimization Tools and Procedures

[Terry Gardner]

If you have the code in a workable configuration, you can test it easily with a SQL query job using SLAMD (http://slamd2.dev.java.net). This generate load that may point to indexing problems and other performance-related problems.

On Jun 19, 2009, at 11:16 AM, Edward Song wrote:

Here's a Friday discussion.


that I'm an expert.  My last project I did run into some design and
architecture issues that needed a little bit of reworking and
refactoring.  To help avoid this, I want to get better and have more
confidence moving forward in a project that my schema design has been

a good effort.


with some tool at the early design phases that will help us give us
confidence that our initial schema, indexes and queries are optimized?

As an application developer, I can write SQL pretty well, but I wouldn't say optimized, or at least perform some excercise to let me know that I gave it Any insights on how as application developers, we can perform some exercise

--
terry.gard...@sun.com
Blog: http://blogs.sun.com/terrygardner
Blog: http://ff1959.wordpress.com
Twitter: http://twitter.com/tgardner
SLAMD: http://slamd2.dev.java.net
Skype: Terry_J_Gardner

"Potentia vobiscum"

smime.p7s
Description: S/MIME cryptographic signature