---
title: 10.4.4.2.5 Setfinder Query – Temp Table Properties
description: A simple setfinder query is one that does not use a temp table during the querying process. The ability to not use a temp table will speed up the process of running a query against your database. The maximum number…
url: "https://i2b2.org/docs/10-4-4-2-5-setfinder-query-temp-table-properties/"
updated: "2026-09-15"
category: "i2b2 Installation Guide / Chapter 4. Server Install Guide / B. Legacy Approach - Build Each Cell from Source / Chapter 10. Data Repository (CRC) Cell Install / 10.4 Configuration / 10.4.4 Configure the CRC Properties / 10.4.4.2 Optional Performance Properties"
---

# 10.4.4.2.5 Setfinder Query – Temp Table Properties

A simple setfinder query is one that does not use a temp table during the querying process. The ability to not use a temp table will speed up the process of running a query against your database. The maximum number of items that can be in a query without using a temp table is defined in the **CRC setfinder query without using temp table** section of the **crc.properties** file.

1. In the **crc.properties** file scroll to the section called **CRC setfinder query without using temp table**.

2. Edit the default value to reflect the maximum number of items that can be in a query before using the temp table.

  **CRC setfinder query without using temp table**

edu.harvard.i2b2.crc.setfinderquery.skiptemptable.maxconcept=40

3. Save your changes. You can close the file if you do not want to edit any more of the optional properties defined in the next few sections.