I have a query like:
select * from tableA where id in (1,2,3,..)
List of ids ids very long about 200 000 ids.
There is an clustered index on id colums.
The same query on mysql rus fast but on MS it cant take about 20 minuts (on mysql takes few second).
How can I resolve this?