Posted by boa sema on 02/01/07 07:39

Way back when, and at least in version 7 IIRC, the query optimizer gave
up when the where clause in a statement contained more than 4 search
conditions.

Does anyone know if such a limitation still exist in MS SQL 2005? The
BOL seems to be silent on the issue.

Boa

• Next in forum: Re: MS SQL 2005: Where clause and optimizer
• Prev in forum: Re: Querying towards a responsive UI
• Thread view: MS SQL 2005: Where clause and optimizer

[Reply to this message]