There is insufficient system memory in resource pool 'internal' to run this query

Question

I am facing the titled error. I searched for the issue on google found manmy people facing the same issue but non of them matches my scenario.

I have a simple query but there are 100,000 of conditions. query looks like.

SELECT TEXT,LANG,PLANTCODE FROM DROP_VALUE WHERE FIELDNAME='PROFIT_CTR' AND PLANTCODE IN ('953306843','469940529','293294653',......100,000 conditions)

I am using eclipse JUNO and (on the same local machine) sql server 2008 r2 enterprise edition.
Windows 7 professional
8 gb RAM
i3 processor.
3gb memory allocated for JVM.

Please suggest me possible causes.

Answer 1

If you can, move the conditions to a table structure and JOIN to it.