Here are best-practice samples for common queries, including retrieving subscriptions, products, accounts, attachments, and invoices.

Best-practice samples for common queries

Learn about best practices to query data by using Data Query.

General best practices

Indexed fields are essential for optimizing data retrieval and search operations in databases, enhancing query performance and efficiency.

Indexed fields

<body><main xmlns:jcm-link-man="http://jorsek.com/content-management/modules/linkmanagement" role="main"><article role="article" id="concept-ac-1679" aria-labelledby="ariaid-title1"><h1 class="title topictitle1" id="ariaid-title1">Best practices when writing data queries</h1><div class="body conbody"><p class="shortdesc">Here are best practices when writing data queries.</p><ul class="ul"><li class="li">
                <p class="p"> <a class="xref" href="/zuora-platform/data/best-practices-when-writing-data-queries/general-best-practices">General best practices</a> </p>
            </li><li class="li">
                <p class="p"> <a class="xref" href="/zuora-platform/data/best-practices-when-writing-data-queries/indexed-fields">Indexed fields</a>
                </p>
            </li><li class="li">
                <p class="p"> <a class="xref" href="/zuora-platform/data/best-practices-when-writing-data-queries/best-practice-samples-for-common-queries">Best-practice samples for common queries</a>
                </p>
            </li></ul></div></article></main></body>

Browse Platform features that assists you to process data

Data

This reference provides an overview of available tables in Data Query, differences between tenants, and methods to retrieve table lists using the SHOW TABLES statement and Data Query Schema Browser.

Available tables

Here are best practices when writing data queries.

Best practices when writing data queries

zuora-platform/data/best-practices-when-writing-data-queries

data/best-practices-when-writing-data-queries

<body><main xmlns:jcm-link-man="http://jorsek.com/content-management/modules/linkmanagement" role="main"><article role="article" id="topic-9918" aria-labelledby="ariaid-title1"><h1 class="title topictitle1" id="ariaid-title1">zuora-footer</h1><div class="body"><div class="div custom-footer">
            <div class="div left-column"> <img class="image logo" src="https://zuora.deploy.heretto.com/v4/deployments/QPAZk6lsgXwvotedNERE/object/91e2cbe5-f650-465d-b2e0-001b64f6ed08?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJodHRwczovL2pvcnNlay5jb20vZXpkX29yZ2FuaXphdGlvbiI6Inp1b3JhIiwiaHR0cHM6Ly9qb3JzZWsuY29tL2V6ZC9vYmplY3RfdXVpZCI6IjkxZTJjYmU1LWY2NTAtNDY1ZC1iMmUwLTAwMWI2NGY2ZWQwOCIsImV4cCI6MTc4NzEzNTA3MCwianRpIjoiOTMzOTIzMjBiZTZiNGQ3YmJmYTdiZTk2Zjc2MWE1NWYiLCJodHRwczovL2pvcnNlay5jb20vZXpkX2ZpbGVzZXQiOiJRUEFaazZsc2dYd3ZvdGVkTkVSRSJ9.pMSAkZJDUeBasG5nC-IcQ-Bx6axA6Of1yA2YnbZCguU">
            </div>
            <div class="div right-column">
                <p class="p"><a class="xref j-external-link" href="https://developer.zuora.com" target="_blank">Developer Center</a></p>
                <p class="p"><a class="xref j-external-link" href="https://www.zuora.com" target="_blank">Privacy Statement</a></p>
                <p class="p"><a class="xref j-external-link" href="https://www.zuora.com" target="_blank">Terms and Conditions</a></p>
                <p class="p"><a class="xref j-external-link" href="https://www.zuora.com" target="_blank">Cookie Preference</a></p>
                <p class="p">© 2025 Zuora Inc.</p>
            </div>
        </div></div></article></main></body>

zuora-footer

Developer Center

Find training and certifications to achieve your business needs

Zuora University

Connect, share, collaborate with the Zuora Community

Zuora Community

Fundamental Zuora information you should know

Basics

Explore entitlements for all Zuora product offerings

Entitlements

Learn the support and service policies at Zuora

Support and policies

Zuora Product Documentation

Monetize new offerings, create and manage subscriptions, and invoice customers

Zuora Billing

Collect and manage payments, reduce fraud, and boost acceptance

Zuora Payments

Build, customize, extend, and integrate with Zuora

Zuora Platform

Configure, price, and quote with speed and ease

Zuora CPQ

Optimize digital subscription Journeys and boost revenue growth

Zephr

Recognize, reconcile, and analyze revenue automatically

Zuora Revenue

Automate invoicing and collections to improve cash flow, mitigate financial risk, and ensure financial accuracy

Accounts Receivable

Analyze data, automate tasks, and interact with Zuora using AI

Zuora AI

What is new and what is changing for every release

Release Notes

Overview

System management

Data management

Manage security, identity, access control, and data protection across the platforms

Security and identity

Manage access to data across multiple entities and organizations, ensuring the right users have the appropriate level of visibility and control

Organization and entity management

Extensibility

Browse features that help with your integration with Zuora

Welcome to Zuora Product Documentation

Explore our rich library of product information

Best practices when writing data queries

zuora-footer