is it possible to keep fuzzy lookup index always in memory even after SSIS package has finished with execution? point here is, if it can be done then, when we call again same SSIS package, we don’t have any warm-up time because index is already in memory so we have better performance.
We have seen that when we call out SSIS package index is loaded in memory and as soon as SSIS package is done , it unload from memory. we always want to keep this in memory
Any suggestion how it can be achieved or any other alternative