0 votes
7 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?
ago by helgy716 (120 points)
edited ago by 0 | 7 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.

451 questions

463 answers

474 comments

659 users

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

Categories