Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →An ad hoc query is a query written to answer a particular information need, often immediately, instead of a predefined request that runs repeatedly. In data warehousing, it usually means a query composed for on-the-spot use and adjusted as someone explores the results. In SQL Server terminology, it can have a narrower meaning: a single query that is not part of a stored procedure and is not parameterized or prepared.
What makes a query ad hoc?
The defining feature is its purpose: someone has a specific question and writes a query to answer it. A standard report or saved query may not cover that question, so the user composes a statement for the immediate task. The query is often exploratory; the user may change its filters, columns, or calculations in response to what the first results show.
As an Amazon Associate I earn from qualifying purchases.
Teradata Vantage documentation describes the data-warehouse meaning as a query composed for immediate performance, unlike a permanent query stored in a macro, stored procedure, or SQL application and run repeatedly without alteration. The wording is from its Vantage 17.20 documentation: Usage Considerations: Ad Hoc Queries.
Free tools Windows power users keep installed
One-click scans. No signup required.
Ad hoc does not mean the same thing in every database context
General and data warehouse usage
In general discussion, “ad hoc” describes why and how the query is used: it is composed for a particular, often one-time question and may be refined interactively. The term does not, by itself, specify how the database prepares or executes the statement.
#1 Best Overall
SQL Server’s narrower technical usage
In Redgate’s explanation of SQL Server, an ad hoc query is a single query that is not included in a stored procedure and is not parameterized or prepared. This is a more specific classification than the general purpose-driven meaning. A statement typed for an immediate request is not automatically an ad hoc query under that definition: a changing hard-coded value may be parameterized by SQL Server. Redgate explains this distinction in What Is An Ad Hoc Query?.
Example of an ad hoc query
An analyst who needs a quick list of names might write:
SELECT LastName, FirstName FROM Person.Person;This illustrates a statement composed to meet a particular request. It is not proof that SQL Server will classify every such statement as an ad hoc query under its narrower technical meaning; parameterization and preparation matter there.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →How it differs from a reusable query
A reusable query, report, stored procedure, or SQL application is designed to serve a recurring need. An ad hoc query is composed for the question at hand. These are contrasts in intended use, not interchangeable database object types: a saved select query, for example, can be reused as the source for a form, report, or another query, as Microsoft explains in its introduction to queries.
Rank #3
| Type or context | What it means |
|---|---|
| Ad hoc query, general usage | Composed for a particular immediate question, often as part of an exploratory workflow. |
| SQL Server ad hoc query, in Redgate’s explanation | A single query outside a stored procedure that is not parameterized or prepared. |
| Reusable query or report | Saved or otherwise designed for repeated use; it may be a saved query, stored procedure, report, or application query. |
Are ad hoc queries bad for performance?
No. One-off queries are a normal part of database work, and the label alone does not establish that a query is slow or harmful. In SQL Server, workload details can matter: Microsoft documents the optimize for ad hoc workloads server configuration option as a possible way to reduce memory use when single-use ad hoc plans consume a significant share of memory on an OLTP server. Microsoft also discusses forced parameterization and warns that parameter sensitivity can cause performance issues. These are workload-specific considerations, not reasons to avoid ad hoc queries categorically. See Microsoft’s documentation on optimize for ad hoc workloads.
What can a query do?
A query is not limited to returning a list of rows. Depending on its type and the database, it can filter or combine information, calculate or summarize values, and change data. Microsoft’s query introduction explains the role of queries, while its guide to creating a simple select query covers a basic retrieval example.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
