Skip to content Skip to sidebar Skip to footer
Showing posts with the label Unique Index

Counting Distinct Rows Using Recursive Cte Over Non-distinct Index

Given the following schema: CREATE TABLE identifiers ( id TEXT PRIMARY KEY ); CREATE TABLE days … Read more Counting Distinct Rows Using Recursive Cte Over Non-distinct Index