0 votes
80 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 | 80 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.

484 questions

494 answers

488 comments

677 users

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

Categories