0 votes
66 views
the request that contains OR in the query works very slowly. For example:

---

select top 10
pm, ra, dec
from gaia_dr3.gaia_source
where pm < 1

----

and

---

select top 10
pm, ra, dec
from gaia_dr3.gaia_source
where
pm > 2

---

but the query:
select top 10
pm, ra, dec
from gaia_dr3.gaia_source
where pm < 1 OR pm > 2

works very slowly.

Any suggestions?
by helgy716 (120 points)
edited by 0 | 66 views

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

467 questions

479 answers

477 comments

667 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.

Categories