My application does select with were condition using IN function on only one table and I see slow response from front end. Please clarify me, do we have options like memory tables or is it possible to pin entire table in memory or do we have any option to improve only select statement.
