---
schema_version: "1"
id: 3db365a7521a13316c9531c6ba9d78716aced841e999a7b90adb3548f47898c1
title: Boost Query Performance and Data Efficiency with Semi-Joins and Anti-Joins (Generally Available)
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/release-notes/262-0-0/rn_bi_dashboard_semi_anti_join_ga.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_bi_dashboard_semi_anti_join_ga.htm&release=262.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3c3b5d04a16b6101ff6707ddbd32e9240c6ad2965ba57dd70f3a126ebaf8ba92
description: You can now add semi and anti joins to your queries to identify duplicate and non-matching rows without coding. This update not only accelerates query performance by retrieving only essential data but also empowers you to perform advanced data analysis more efficiently, making complex data insights accessible to all. This feature is now generally available.
products:
  - Cross Cloud
release: "262"
---
# Boost Query Performance and Data Efficiency with Semi-Joins and Anti-Joins (Generally Available)

You can now add semi and anti joins to your queries to identify duplicate and non-matching rows without coding. This update not only accelerates query performance by retrieving only essential data but also empowers you to perform advanced data analysis more efficiently, making complex data insights accessible to all. This feature is now generally available.

**Where:** This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

**How:** Open a lens. From the Add menu, select **Join Data Source**.

![Clicking the Join Data Source button.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-release-notes-salesforce_release_notes-262-0-0-production-enus/e945111b-3e0a-4011-accc-d5949363bfcc/salesforce_release_notes/images/analytics/rn_bi_dashboard_semi_anti_join.png)

Select a join type and fields to match between the datasets. You can select up to 5 pairings.

![Selecting a join type and matching fields.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-release-notes-salesforce_release_notes-262-0-0-production-enus/e945111b-3e0a-4011-accc-d5949363bfcc/salesforce_release_notes/images/analytics/rn_bi_dashboard_semi_anti_join_2.png)

#### See Also

- [_Salesforce Help_: Optimize Data Operations with Semi and Anti Joins](https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_data_join.htm&language=en_US)