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

460 questions

473 answers

475 comments

662 users

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

Categories