Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqlite> CREATE INDEX airports_continent_iso_country_iso_region_municipality ON airports (continent, iso_country, iso_region, municipality);
- 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"));
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- 0|0|0|SEARCH TABLE airports USING INDEX airports_continent_iso_country_iso_region_municipality (continent=? AND iso_country=? AND iso_region=? AND municipality=?)
- sqlite>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement