Add a new parameter in the crc.properties file that allows a site to use a temp table instead of a 'WITH' clause when running a CRC query. In some environments using a temp table allows the query to run more efficiently and process the request faster.

Parameter Name: edu.harvard.i2b2.crc.setfinderquery.constraintlogic
Located In: crc.properties file
Behavior:
   Value = TEMP or TEMPTABLES temp tables will be used when building queries.
   Value = "WITH" current query logic is used

If the parameter is missing from the crc.properties file the system will current query logic (WITH clause).


IMPORTANT: This change only affects SQL Server databases. Both PostgreSQL and Oracle do not have the capabilities of using temp tables. They will continue to use the WITH clause.