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	856	June 15, 2020
Very Slow Query Performance SQL	14	796	January 12, 2023
Limited performance during query CrateDB	15	1177	May 26, 2021
Cratedb error when using 'SELECT DISTINCT ON' CrateDB	9	520	February 11, 2023
Using common table expressions to speed up queries Tutorials sql , performance	0	666	February 22, 2024