Skip to content

Instantly share code, notes, and snippets.

@gratzc

gratzc/big-offsets-5.sql

Created March 25, 2019 16:12
Show Gist options
  • Save gratzc/4bd620fb6db272382f4e8cafe13e3cad to your computer and use it in GitHub Desktop.
Save gratzc/4bd620fb6db272382f4e8cafe13e3cad to your computer and use it in GitHub Desktop.
Download ZIP
Raw
big-offsets-5.sql
SELECT country, city, META().id
FROM `travel-sample` use index (ixtypectcy)
WHERE type = "hotel"
AND country >= 0
AND city >= 0
AND META().id > 0
ORDER BY country, city, META().id
LIMIT 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment