By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
COUNT(*) |
---|
4296875 |
selectid | order | from | detail |
---|---|---|---|
0 | 0 | 0 | SCAN TABLE dbsnp USING COVERING INDEX chromosome_IX |
strftime('%Y-%m-%d %H-%M-%f','now') |
---|
2017-12-27 21-15-08.175 |
chromosome |
---|
TEST_1 |
TEST_2 |
TEST_3 |
strftime('%Y-%m-%d %H-%M-%f','now') |
---|
2017-12-27 21-15-08.492 |
selectid | order | from | detail |
---|---|---|---|
0 | 0 | 0 | SEARCH TABLE dbsnp USING COVERING INDEX chromosome_IX |
strftime('%Y-%m-%d %H-%M-%f','now') |
---|
2017-12-27 21-15-08.492 |
MIN(chromosome) |
---|
TEST_1 |
selectid | order | from | detail |
---|---|---|---|
0 | 0 | 0 | SEARCH TABLE dbsnp USING COVERING INDEX chromosome_IX (chromosome>?) |
chromosome |
---|
TEST_2 |
selectid | order | from | detail |
---|---|---|---|
0 | 0 | 0 | SEARCH TABLE dbsnp USING COVERING INDEX chromosome_IX (chromosome>?) |
chromosome |
---|
TEST_3 |
strftime('%Y-%m-%d %H-%M-%f','now') |
---|
2017-12-27 21-15-08.496 |