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

Best-practice samples for common queries

General best practices

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

Indexed fields

<body id="concept-ac-1679"><main role="main"><article role="article" 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/data-query/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/data-query/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/data-query/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>

zuora-platform/data/data-query/overview-of-data-query

Data Query

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/data-query/best-practices-when-writing-data-queries

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

<body id="topic-9918"><main role="main"><article role="article" 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.eyJodHRwczovL2pvcnNlay5jb20vZXpkX29yZ2FuaXphdGlvbiI6Inp1b3JhIiwiaHR0cHM6Ly9qb3JzZWsuY29tL2V6ZC9vYmplY3RfdXVpZCI6IjkxZTJjYmU1LWY2NTAtNDY1ZC1iMmUwLTAwMWI2NGY2ZWQwOCIsImV4cCI6MTc2MDUyMjcxMSwianRpIjoiZGUyNWQwZTQ4ZWQzNDcyNThkZGM0NjQ0YjFlZTQxZTciLCJodHRwczovL2pvcnNlay5jb20vZXpkX2ZpbGVzZXQiOiJKbjNMVkF3VDYwTEVIeFU4clBzYiJ9.aW7VbZWpX1glKkcdkTw1wPw9suS9h6lZbYdX-9O1ZlI">
            </div>
            <div class="div right-column">
                <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

Welcome to Zuora Product Documentation

Explore our rich library of product information

Best practices when writing data queries

zuora-footer