On Fri, May 22, 2020 at 2:09 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Friday, May 22, 2020, postgann2020 s <postgann2020@xxxxxxxxx> wrote:We are looking for a better query than "SELECT 1 FROM schema.table_name WHERE column1=structure_id1" this query for data validation.
If many rows match potentially, then wrapping the query with select exists(old_query) would allow the execution to bail asap.