Very Computer

assume I have the following query:

select * from Customer c
inner join Phone p
on p.custId = c.custId
where p.PhoneNo = '1234567'
and p.PhoneNoAreaCd = '890'
force order

does the force order hint also applies to the sequence of the where
condition?  As a simplified example the impact of force order on the order
of the table is not necessarily justified here.  But my question is about
its effect on the where conditions.  Thanks for your looking into this.

Quentin

FORCE ORDER
Specifies that the join order indicated by the query syntax is preserved
during query optimization

Based on this description, it does not necessarily affect the WHERE
clause.

If you want to test it, and you are running SQL2K, then you can create a
UDF that does some logging, and transform your statement into:

select ...
where dbo.MyUDF(p.PhoneNo)='1234567'
and   dbo.MyUDF(p.PhoneNoAreaCd)='890'
option (force order)

Gert-Jan