1818 shaares
37 private links
37 private links
295 results
tagged
SQL
Réponse de RhodiumToad sur twitter :
BTW, If there are many duplicates (e.g. on average more than 5 of each distinct value) and the value has an index then https://wiki.postgresql.org/wiki/Loose_indexscan … beats all other methods, being O(D logN) rather than O(N) or O(N logN) where D=number of distinct vals