> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/docs/platform/data/data-query/best-practices-when-writing-data-queries/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Best practices when writing data queries

> Here are best practices when writing data queries.

Here are best practices when writing data queries.

* [General best practices](/docs/platform/data/data-query/best-practices-when-writing-data-queries/general-best-practices)
* [Indexed fields](/docs/platform/data/data-query/best-practices-when-writing-data-queries/indexed-fields)
* [Best-practice samples for common queries](/docs/platform/data/data-query/best-practices-when-writing-data-queries/best-practice-samples-for-common-queries)

> Here are best practices when writing data queries.

## Docs

- [Best-practice samples for common queries](https://zuora.ferndocs.com/docs/platform/data/data-query/best-practices-when-writing-data-queries/best-practice-samples-for-common-queries.md): Here are best-practice samples for common queries, including retrieving subscriptions, products, accounts, attachments, and invoices.
- [General best practices](https://zuora.ferndocs.com/docs/platform/data/data-query/best-practices-when-writing-data-queries/general-best-practices.md): Learn about best practices to query data by using Data Query.
- [Indexed fields](https://zuora.ferndocs.com/docs/platform/data/data-query/best-practices-when-writing-data-queries/indexed-fields.md): Indexed fields are essential for optimizing data retrieval and search operations in databases, enhancing query performance and efficiency.