---
title: "Indexes: Indexing Related Documents"
url: "https://docs.ravendb.net/6.2/indexes/indexing-related-documents"
version: "6.2"
language: "csharp"
---

# Indexes: Indexing Related Documents

> Client language: C#. Also available for [Java](https://docs.ravendb.net/6.2/indexes/indexing-related-documents.java.md), [Python](https://docs.ravendb.net/6.2/indexes/indexing-related-documents.python.md), [PHP](https://docs.ravendb.net/6.2/indexes/indexing-related-documents.php.md), [Node.js](https://docs.ravendb.net/6.2/indexes/indexing-related-documents.nodejs.md).
>
> RavenDB publishes an official agent skill for coding assistants at https://docs.ravendb.net/skills/ravendb/SKILL.md (also installable with `npx skills add ravendb/skills`). The skill describes itself as: "Read this before writing any RavenDB query, client call or /databases/ request. Covers server setup, document modelling, the Node.js, .NET and Python clients, RQL, indexes, vector search and AI agents. Code written from recall tends to run and return the wrong rows, because RQL resembles SQL and the clients take field names as plain strings."

> **Note**
>
> - As described in [modeling considerations in RavenDB](https://ravendb.net/learn/inside-ravendb-book/reader/4.0/3-document-modeling#summary),  
>   it is recommended for documents to be: independent, isolated, and coherent.  
>   However, to accommodate varied models, **documents can reference other documents**.
>
> - The related data from a referenced (related) document can be indexed,  
>   this will allow querying the collection by the indexed related data.
>
> - The related documents that are loaded in the index definition can be either **Tracked** or **Not-Tracked**.
>
> - In this page:
>
>   - [What are related documents](#what-are-related-documents)
>
>   - [Index related documents - With tracking](#index-related-documents---with-tracking)
>     - [Example I - basic](#example-i---basic)
>     - [Example II - list](#example-ii---list)
>     - [Tracking implications](#tracking-implications)
>
>   - [Index related documents - No tracking](#index-related-documents---no-tracking)
>     - [Example III - no tracking](#index-related-documents---no-tracking)
>     - [No-tracking implications](#no-tracking-implications)
>
>   - [Document changes that cause re-indexing](#document-changes-that-cause-re-indexing)
>
>   - [LoadDocument Syntax](#loaddocument-syntax)

## What are related documents

- Whenever a document references another document, the referenced document is called a **Related Document**.

- In the image below, document `products/34-A` references documents `categories/1-A` & `suppliers/16-A`,  
  which are considered Related Documents.
  ![Referencing related documents](https://docs.ravendb.net/assets/images/index-related-documents-2273b67aaa6012ed2a846505b82d9e43.png)

## Index related documents - With tracking

### Example I - basic

- **What is tracked**:  
  Both the documents from the **indexed collection** and the **indexed related documents** are tracked for changes.  
  Re-indexing will be triggered per any change in either collection.  
  (See changes that cause re-indexing [here](#document-changes-that-cause-re-indexing)).

- **The index**:  
  Following the above `Product - Category` relationship from the Northwind sample database,  
  an index defined on the Products collection can index data from the related Category document.

#### LINQ-index

```csharp
public class Products_ByCategoryName : AbstractIndexCreationTask<Product>
{
  public class IndexEntry
  {
      public string CategoryName { get; set; }
  }

  public Products_ByCategoryName()
  {
      Map = products => from product in products
          
          // Call LoadDocument to load the related Category document
          // The document ID to load is specified by 'product.Category'
          let category = LoadDocument<Category>(product.Category)
          
          select new IndexEntry
          {
              // Index the Name field from the related Category document
              CategoryName = category.Name
          };
              
          // Since NoTracking was Not specified,
          // then any change to either Products or Categories will trigger reindexing 
  }
}
```

#### JavaScript-index

```csharp
public class Products_ByCategoryName_JS : AbstractJavaScriptIndexCreationTask
{
  public Products_ByCategoryName_JS()
  {
      Maps = new HashSet<string>()
      {
          // Call method 'load' to load the related Category document
          // The document ID to load is specified by 'product.Category'
          // The Name field from the related Category document will be indexed
          
          @"map('products', function(product) {
              let category = load(product.Category, 'Categories')
              return {
                  CategoryName: category.Name
              };
          })"
          
          // Since noTracking was Not specified,
          // then any change to either Products or Categories will trigger reindexing 
      };
  }
}
```

- **The query**:  
  We can now query the index for Product documents by `CategoryName`,  
  i.e. get all matching Products that reference a Category that has the specified name term.

#### Query(sync)

```csharp
IList<Product> matchingProducts = session
  .Query<Products_ByCategoryName.IndexEntry, Products_ByCategoryName>()
  .Where(x => x.CategoryName == "Beverages")
  .OfType<Product>()
  .ToList();
```

#### Query(async)

```csharp
IList<Product> matchingProducts = await asyncSession
  .Query<Products_ByCategoryName.IndexEntry, Products_ByCategoryName>()
  .Where(x => x.CategoryName == "Beverages")
  .OfType<Product>()
  .ToListAsync();
```

#### RQL

```sql
from index "Products/ByCategoryName"
where CategoryName == "Beverages"
```

### Example II - list

- **The documents**:

```csharp
// The referencing document
public class Author
{
  public string Id { get; set; }
  public string Name { get; set; }
  
  // Referencing a list of related document IDs
  public List<string> BookIds { get; set; }
}

// The related document
public class Book
{
  public string Id { get; set; }
  public string Name { get; set; }
}
```

- **The index**:  
  This index will index all names of the related Book documents.

#### LINQ-index

```csharp
public class Authors_ByBooks : AbstractIndexCreationTask<Author>
{
  public class IndexEntry
  {
      public IEnumerable<string> BookNames { get; set; }
  }

  public Authors_ByBooks()
  {
      Map = authors => from author in authors
          select new IndexEntry
          {
              // For each Book ID, call LoadDocument and index the book's name
              BookNames = author.BookIds.Select(x => LoadDocument<Book>(x).Name)
          };
      
      // Since NoTracking was Not specified,
      // then any change to either Authors or Books will trigger reindexing 
  }
}
```

#### JavaScript-index

```csharp
public class Authors_ByBooks_JS : AbstractJavaScriptIndexCreationTask
{
  public Authors_ByBooks_JS()
  {
      Maps = new HashSet<string>()
      {
          // For each Book ID, call 'load' and index the book's name
          @"map('Author', function(author) {
              return {
                  Books: author.BooksIds.map(x => load(x, 'Books').Name)
              }
          })"
          
          // Since NoTracking was Not specified,
          // then any change to either Authors or Books will trigger reindexing 
      };
  }
}
```

- **The query**:  
  We can now query the index for Author documents by a book's name,  
  i.e. get all Authors that have the specified book's name in their list.

#### Query(sync)

```csharp
// Get all authors that have books with title: "The Witcher"
IList<Author> matchingAuthors = session
  .Query<Authors_ByBooks.IndexEntry, Authors_ByBooks>()
  .Where(x => x.BookNames.Contains("The Witcher"))
  .OfType<Author>()
  .ToList();
```

#### Query(async)

```csharp
// Get all authors that have books with title: "The Witcher"
IList<Author> matchingAuthors = await asyncSession
  .Query<Authors_ByBooks.IndexEntry, Authors_ByBooks>()
  .Where(x => x.BookNames.Contains("The Witcher"))
  .OfType<Author>()
  .ToListAsync();
```

#### RQL

```sql
// Get all authors that have books with title: "The Witcher"
from index "Authors/ByBooks"
where BookNames = "The Witcher"
```

> **Info**
>
> ### Tracking implications
>
> - Indexing related data with tracking can be a useful way to query documents by their related data.  
>   However, that may come with performance costs.
>
> - **Re-indexing** will be triggered whenever any document in the collection that is referenced by `LoadDocument` is changed.
>   Even when indexing just a single field from the related document, any change to any other field will cause re-indexing.
>   (See changes that cause re-indexing [here](#document-changes-that-cause-re-indexing)).
>
> - Frequent re-indexing will increase CPU usage and reduce performance,  
>   and index results may be stale for prolonged periods.
>
> - Tracking indexed related data is more useful when the indexed related collection is known not to change much.

## Index related documents - No tracking

### Example III - no tracking

- **What is tracked**:
  - Only the documents from the **indexed collection** are tracked for changes and can trigger re-indexing.  
    Any change done to any document in the **indexed related documents** will Not trigger re-indexing.  
    (See changes that cause re-indexing [here](#document-changes-that-cause-re-indexing)).

- **The index**:

#### LINQ-index

```csharp
public class Products_ByCategoryName_NoTracking : AbstractIndexCreationTask<Product>
{
  public class IndexEntry
  {
      public string CategoryName { get; set; }
  }

  public Products_ByCategoryName_NoTracking()
  {
      Map = products => from product in products
          
          // Call NoTracking.LoadDocument to load the related Category document w/o tracking
          let category = NoTracking.LoadDocument<Category>(product.Category)
          
          select new IndexEntry
          {
              // Index the Name field from the related Category document
              CategoryName = category.Name
          };
              
          // Since NoTracking is used -
          // then only the changes to Products will trigger reindexing 
  }
}
```

#### JavaScript-index

```csharp
public class Products_ByCategoryName_NoTracking_JS : AbstractJavaScriptIndexCreationTask
{
  public Products_ByCategoryName_NoTracking_JS()
  {
      Maps = new HashSet<string>()
      {
          // Call 'noTracking.load' to load the related Category document w/o tracking
          
          @"map('products', function(product) {
              let category = noTracking.load(product.Category, 'Categories')
              return {
                  CategoryName: category.Name
              };
          })"
          
          // Since noTracking is used -
          // then only the changes to Products will trigger reindexing
      };
  }
}
```

- **The query**:  
  When querying the index for Product documents by `CategoryName`,  
  results will be based on the related data that was **first indexed** when the index was deployed.

#### Query(sync)

```csharp
IList<Product> matchingProducts = session
  .Query<Products_ByCategoryName_NoTracking.IndexEntry, Products_ByCategoryName_NoTracking>()
  .Where(x => x.CategoryName == "Beverages")
  .OfType<Product>()
  .ToList();
```

#### Query(async)

```csharp
IList<Product> matchingProducts = await asyncSession
  .Query<Products_ByCategoryName_NoTracking.IndexEntry, Products_ByCategoryName_NoTracking>()
  .Where(x => x.CategoryName == "Beverages")
  .OfType<Product>()
  .ToListAsync();
```

#### RQL

```sql
from index "Products/ByCategoryName/NoTracking"
where CategoryName == "Beverages"
```

> **Info**
>
> ### No-tracking implications
>
> - Indexing related data with no-tracking can be a useful way to query documents by their related data.  
>   However, that may come with some data accuracy costs.
>
> - **Re-indexing** will Not be triggered when documents in the collection that is referenced by `LoadDocument` are changed.
>   Although this may save system resources, the index entries and the indexed terms may not be updated with the current state of data.
>
> - Indexing related data without tracking is useful when the indexed related data is fixed and not supposed to change.

## Document changes that cause re-indexing

- The following changes done to a document will trigger re-indexing:
  - Any modification to any document field (not just to the indexed fields)
  - Adding/Deleting an attachment
  - Creating a new Time series (modifying existing will not trigger)
  - Creating a new Counter (modifying existing will not trigger)

- Any such change done on any document in the **indexed collection** will trigger re-indexing.

- Any such change done on any document in the **indexed related documents** will trigger re-indexing  
  only if `NoTracking` was Not used in the index definition.

## LoadDocument syntax

#### Syntax for LINQ-index:

```csharp
T LoadDocument<T>(string relatedDocumentId);

T LoadDocument<T>(string relatedDocumentId, string relatedCollectionName);

T[] LoadDocument<T>(IEnumerable<string> relatedDocumentIds);

T[] LoadDocument<T>(IEnumerable<string> relatedDocumentIds, string relatedCollectionName);
```

#### Syntax for JavaScript-index:

```javascript
object load(relatedDocumentId, relatedCollectionName);
```

| Parameters | | |
| - | - | - |
| **relatedDocumentId** | `string` | ID of the related document to load |
| **relatedCollectionName** | `string` | The related collection name |
| **relatedDocumentIds** | `IEnumerable<string>` | A list of related document IDs to load |

## See also

- [Indexing Basics](https://docs.ravendb.net/6.2/indexes/indexing-basics.md)
- [Indexing Hierarchical Data](https://docs.ravendb.net/6.2/indexes/indexing-hierarchical-data.md)
- [Indexing Spatial Data](https://docs.ravendb.net/6.2/indexes/indexing-spatial-data.md)
- [Indexing Polymorphic Data](https://docs.ravendb.net/6.2/indexes/indexing-polymorphic-data.md)
- [Basics](https://docs.ravendb.net/6.2/indexes/querying/query-index.md)
- [Query Overview](https://docs.ravendb.net/6.2/client-api/session/querying/how-to-query.md)
