Hi there you all. Is someone experiencing this: I have migrated my database
from SQL server 7.0 to sql server 2000, so far so good until a little thing
appeared on the horizon. My asp pages use lots of SQL statements that look
like this:

SELEct ...
from a
inner join b on a.i=b.i
where a IN (....)

This sure worked in the 7.0 server -I used this approach for the nested selects
approach didn't worked pretty much good-, but what is happening on the 2000
installation? queries that taked seconds on the other version now take minutes!
.. 1 second vs 2 minutes, it seems as if the server always picks up a table
scan approach to resolve the queries.

Would someone lend me a hand?