---
title: Fields Used To Coalesce Records In A Table Transform Map Should Be Indexed
description: "Impact Area Performance Severity Medium Affected Element Field Map Rule number **SN-0371** ## Impact Fields marked as coalesce in a Table Transform Map will be used to match source and destination records. If the field is unindexed in the target…"
url: "https://community-staging.qualityclouds.com/qcdocs/qcr/rules/fields-used-to-coalesce-records-in-a-table-transform-map-should-be-indexed/"
updated: "2025-03-21"
category: Rules
---

# Fields Used To Coalesce Records In A Table Transform Map Should Be Indexed

Impact Area

Performance

           Severity

Medium

           Affected Element

Field Map

Rule number

**SN-0371**

## Impact

Fields marked as coalesce in a Table Transform Map will be used to match source and destination records. If the field is unindexed in the target table, and the volume of data on the table is high, queries against that field will be slow, and the performance of the Transform Map will be affected.

## Remediation

Talk to your administrator about adding an index to the required fields.

### Time to fix

15 min