...
select * from events where error && box ra_max,dec_max, ra_min,dec_min
A column error
has been added to the table. It is of type box
and stores ra+dg, dec+dg, ra-dg, dec dg
with dg = 1.°
. The operator &&
means overlaps.
The response time is around 0.9 second.
A R-tree index has been built using the error
boundin box.
The response time is 0.01 seconds.