Re: SQL Optimization Tools and Procedures

2009-06-19 Thread john feng
Judge if the data model designed is optimized the business requirements matter most. First of all, one got to make sure the data model closely represents the business object relationship - functionally properly modeled; then considering the possible production usage situation info gathered before

Re: SQL Optimization Tools and Procedures

2009-06-19 Thread 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