SQL - Query Performance

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data

1 - About

The query performance is the Performance of a query.

Advertising

3 - Query Type

3.1 - 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.

3.2 - OLAP

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