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