Posted by Erland Sommarskog on 05/23/07 07:47

Kurt (nicolas.agrapart@gmail.com) writes:
> You write that there is several technique of optimization, I know a
> few that I always apply. But is there any place where I could find
> those ?

A good book on SQL programming beyond the introductory stuff should
probably cover this. No, I don't have any direct suggestions for titles.

If you give more specifics about your problem, we might able to give some
suggestions.

>> If you have a wild query, you should rather see what you can do to
>> improve it, maybe add an index. Or run in it first on a smaller data
>> set, to verify that the query is logically correct.
>
> The query is correct, tested with a small amount of datas.
> The index are set. I don't really know what I can do more?

Make sure that statistics are up to date, and that tables aren't fragmented
are start. Also investigate the query plan, and verify that this is the best
you can get (which is unlikely given the performance). Query tuning can
sometimes be a difficult matter. You could post the query here together
with table and index definitions. Which version of SQL Server are you
using?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]