SHOW:
|
|
- or go back to the newest paste.
| 1 | sqlite> CREATE INDEX airports_continent_iso_country_iso_region_municipality ON airports (continent, iso_country, iso_region, municipality); | |
| 2 | sqlite> EXPLAIN QUERY PLAN select * from airports where ( ((airports.continent = "AN" and airports.iso_country = "" and airports.iso_region = "" and airports.municipality = "" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "" and airports.municipality = "" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "" ) or (airports.continent = "AF" and airports.iso_country = "DZ" and airports.iso_region = "DZ-01" and airports.municipality = "" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Antartica" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "General Bernardo O'Higgins Base" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Hope Bay" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Isla Rey Jorge" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Laurie Island" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "McMurdo Station" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Queen Maud Land" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Rothera Point" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Seymour Island" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "South Shetland Archipielago- King George Island" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Troll Station" ) or (airports.continent = "AN" and airports.iso_country = "AQ" and airports.iso_region = "AQ-U-A" and airports.municipality = "Waterboat Point" ) or (airports.continent = "AN" and airports.iso_country = "TF" and airports.iso_region = "" and airports.municipality = "" ) or (airports.continent = "AN" and airports.iso_country = "TF" and airports.iso_region = "TF-U-A" and airports.municipality = "" ) or (airports.continent = "AF" and airports.iso_country = "DZ" and airports.iso_region = "DZ-34" and airports.municipality = "" ) or (airports.continent = "AN" and airports.iso_country = "GS" and airports.iso_region = "" and airports.municipality = "" ) or (airports.continent = "AN" and airports.iso_country = "GS" and airports.iso_region = "GS-U-A" and airports.municipality = "" )) and (type = "small_airport" or type = "medium_airport" or type = "large_airport" or type = "heliport" or type = "seaplane_base" or type = "balloonport" or type = "Closed" ) and (scheduled_service = "yes" or scheduled_service = "no")); | |
| 3 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 4 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 5 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 6 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 7 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 8 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 9 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 10 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 11 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 12 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 13 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 14 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 15 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 16 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 17 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 18 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 19 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 20 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 21 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 22 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 23 | 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?) | |
| 24 | sqlite> |
