SQL - Query Performance

Data System Architecture

About

The query performance is the Performance of a query.

Query Type

OLTP

OLTP query are query that comes from an OLTP application. This kind of query retrieve few rows and their performance is generally improved with a index.

OLAP

OLAP query are query that comes from a OLAP application. As they are aggregate query, their performance is generally improved by:





Recommended Pages
Data System Architecture
Data Analysis - Reporting Query

Reporting queries are query: executed periodically to create well-known, pre-defined metrics that will answer questions the financial and operational health of a system (business). Although...
Data System Architecture
Data Analysis - ad-hoc queries (exploratory)

An ad-hoc query is a query created on the fly by an analyst in order to answer specific business questions. It's also known as: speed-of-thought analysis Impromptu query This queries are: constructed...
Data System Architecture
Relational Data Modeling - Aggregate Table (Summary Table)

An Aggregate table is a persistence unit of aggregate data. Aggregate tables are also known as summary table (from summary) materialized view A aggregate is a table that contains the result of a query...
Rewrite
SQL Engine - Query Rewrite

query rewrite is a query performance technique enabled by the query transformer that rewrites the original query to use materialized view instead. As the materialized view (a view stored in a table fashion)...



Share this page:
Follow us:
Task Runner