add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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