Cone search queries to nsc_dr2.meas take forever to run, like it is not indexed?..

Question

I am trying to run e.g. the following simple query, both through TAP and through the web interface, and it never finishes:

SELECT * FROM nsc_dr2.meas WHERE 't' = Q3C_RADIAL_QUERY(ra, dec, 19.56808372996291, -72.6549698220494, 0.008333333333333333)

Answer 1

Thanks for reaching out.

It's best to run the cone search / qc3_radial_query() on the nsc_dr2.object table (just get the 'id' column) and then to JOIN the result with the nsc_dr2.meas table on 'objectid' column in .meas to get the corresponding rows from that table.

We hope this helps!