Does anybody know of a tool that would help you optimize SQL tables (with proper indexes) for a particular query?

Edhy Rijo

Thanks Trent, I will keep looking.



BTW for .NET applications I came across to this one: ANTS Performance Profiler™ from RedGate.



After looking briefly to some videos it looks like a one of those tools that are a MUST to have.

Edhy Rijo

It is good and we have used it in the past. It is a good product and the price point isn't bad. For most things it works really well. However, we now use AQTime from automated QA which doesn't seem to get bogged down when running very large applications. Here is their link: http://www.automatedqa.com/products/aqtime/