/explore
|
You are here 
|
use-the-index-luke.com | ||
| | | | |
modern-sql.com
The FILTER clause extends aggregate functions (SUM, AVG, COUNT, etc.) with an additional WHERE clause. Databases not supporting FILTER can use CASE within the aggregate function instead. |
|
| | | | | ||
| | | | |
postgrespro.com
In previous articles we discussed query execution stages and statistics . Last time, I started on data access methods, namely Sequential scan . Today we will cover Index Scan. This article requires a basic understanding of the index method interface. If words like "operator class" and "access method properties" don't ring a bell, check out my article on indexes from a while back for a refresher. Plain Index Scan Indexes return row version IDs (tuple IDs, or TIDs for short), which can be handled in one of... |
|
| | | | | ||
| | | | |
modern-sql.com
LISTAGG is the new SQL standard version of GROUP_CONCAT or STRING_AGG. LISTAGG supports DISTINCT and provides an ON OVERFLOW clause to control the behavior when exceeding the maximum string length. |
|
| | | | | ||
| | | | |
justinjaffray.com
[AI summary] This technical blog post explains write skew anomalies and how they occur within Snapshot Isolation in databases, providing mathematical proofs and examples to help developers gain intuition about database concurrency control guarantees. |
|
| | | |||
