All,
the answer to our problems turned out to be MS SQL using a clustered rather than non-clustered index when interpreting the following statement:
"Select * from xxxx where a=1 b=2 c=3"
table xxxx had 2 indexes as follows
index 1 : clustered keys : d f a e c b
index 2 : non-clustered...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.