Re: Query with multiples operators BETWEEN

Here they are :

EXPLAIN
(SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5);

NOTICE: QUERY PLAN:

Hash Join (cost=25.02..60.98 rows=33 width=20)
-> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16)
-> Hash (cost=25.00..25.00 rows=10 width=4)
-> Seq Scan on observation o (cost=0.00..25.00 rows=10
width=4)

EXPLAIN

----------------------------------------------------

EXPLAIN
(SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.DE BETWEEN 2 AND 7);

NOTICE: QUERY PLAN:

Hash Join (cost=25.02..60.98 rows=33 width=20)
-> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16)
-> Hash (cost=25.00..25.00 rows=10 width=4)
-> Seq Scan on observation o (cost=0.00..25.00 rows=10
width=4)

EXPLAIN

---------------------------------------------------

EXPLAIN
(SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5
AND o.DE BETWEEN 2 AND 7);

NOTICE: QUERY PLAN:

Nested Loop (cost=0.00..56.67 rows=3 width=20)
-> Seq Scan on observation o (cost=0.00..30.00 rows=1 width=4)
-> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16)

EXPLAIN
--------------------------------------------------
Table Observation has 5000 rows and 10 columns
Table Exposure_Epic has 45000 rows and 6 columns
I haven't create any index
If use ---> >2 and <7 , this is the same result.

Thank you for your help
Renaud THONNART