Databases Reference
In-Depth Information
Typically, these queries exhibit the following traits:
●
Long running from a perspective of time
●
A lot of I/O action
●
Multiple cycles of read
●
Heavily skewed joins
●
Minimal computes
Wide/Narrow
Wide/narrow workloads are queries that are generated by standard reports and dashboards and run
execution on wide columns from more than two tables returning a narrow set of columns in the result
set. The resulting complexity from these queries are impacted by the:
●
Length of the source table
●
Distribution of the table across the storage
●
Data model
●
Data relationship
●
Computation
Typically, these queries exhibit the following traits:
●
Medium cycles of execution (running from a perspective of time)
●
High memory consumption
●
Mixed CPU utilization
●
Lot of computes
Narrow/Wide
Narrow/wide workloads are queries generated by ad-hoc users or analytic users and run execution on
a narrow set of columns from two to four tables returning a wide set of columns in the result set. The
resulting complexity from these queries are impacted by the:
●
Length of the table
●
Distribution of the table across the storage
●
Data model
●
Data relationship
●
Time dimension
●
Semantic layer functionality
Typically, these queries exhibit the following traits:
●
Long running (from a perspective of time)
●
Mixed I/O
●
Multiple cycles of read
●
Heavily skewed joins
●
Heavy computes