Skip to content

Instantly share code, notes, and snippets.

@gratzc

gratzc/big-offsets-6.sql

Created March 25, 2019 16:12
Show Gist options
  • Save gratzc/b7be42d9c84961f8d6c3be8487aa7f35 to your computer and use it in GitHub Desktop.
Save gratzc/b7be42d9c84961f8d6c3be8487aa7f35 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
big-offsets-6.sql
SELECT country, city, META().id
FROM `travel-sample` use index (ixtypectcy)
WHERE type = "hotel"
AND country >= “France”
AND city >= “Avignon”
AND META().id > "038c8a13-e1e7-4848-80ec-8819ff923602"
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