"Reporting Is a Different Workload"

1. What is the primary characteristic that distinguishes reporting queries from OLTP queries?

Reporting queries handle a few rows at a time. Reporting queries require immediate data freshness. Reporting queries process thousands to millions of rows per query. Reporting queries typically perform frequent writes.

2. In the context of reporting workloads, what is the most valuable question to ask regarding data freshness?

Is the report needed right now? How many columns are needed in the report? Is the data freshness acceptable as of last night? What indexes are present on the reporting tables?

3. Which of the following tuning techniques is recommended for improving report performance?

Create narrow, selective indexes. Decouple reporting from OLTP. Minimize row counts without client input. Ignore aggregation in reporting.

4. What is a consequence of running a long report in a database that also handles OLTP workloads?

It improves the buffer pool's efficiency. It can lead to excessive locking and blocking of writers. It reduces the need for indexing on tables. It guarantees immediate data freshness.

Continue: "Do the Work in SQL, Not the Client" → Review this lesson Retake quiz