Skip to content

Commit 07c8f9d

Browse files
David FRANCODavid FRANCO
authored andcommitted
Merge branch 'master' of https://github.com/davidwfranco/sql
2 parents ec00a23 + 7404f44 commit 07c8f9d

File tree

1 file changed

+3
-1
lines changed

1 file changed

+3
-1
lines changed

selectivity.sql

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,6 @@
1-
/* Get the quality of an column or group of columns to be used in an index */
1+
/* Get the quality of an column or group of columns to be used in an index
2+
Returns the total rows on the table, the number of distinct values, and min, avg and max rows returned
3+
using this set of columns*/
24

35
column sum for 9999999999 head 'Total #| Rows'
46
column cnt for 9999999999 head 'Total #| Dist Values'

0 commit comments

Comments
 (0)