Query execution on time distinct values, does it need a full scan?

miguel.arregui May 21, 2020, 6:04pm 1

Are queries for distinct values fast or do we need a full table scan?

Topic		Replies	Views
Bad insert performance (50 values) on SELECT FROM SQL	4	875	June 15, 2020
Very Slow Query Performance SQL	14	845	January 12, 2023
Limited performance during query CrateDB	15	1198	May 26, 2021
Cratedb error when using 'SELECT DISTINCT ON' CrateDB	9	568	February 11, 2023
Using common table expressions to speed up queries Tutorials sql , performance	0	690	February 22, 2024