|
|
Posted by Alexander Kuznetsov on 01/07/06 06:28
>>
page 488 - 489 The Guru's Guide to SQL Server Architecture and
Internals. Ken Henderson gives this code as an example of folding: <<
In fact, Ken Henderson is being very cautious when speaking about
folding. He says that folding occurs "under very limited circumstances,
and the rule of thumb is not to rely on it whenever possible. Just
think: in many cases the optimizer does not even have enough time to
consider all the permutations. Because of that limited time, if the
query is complex, folding is less likely to occur. Naturally, for
really really simple queries that fit on a line or two, folding is more
likely to happen. Unfortunately, most production queries are somewhat
bigger...
Navigation:
[Reply to this message]
|