We are looking for a better query than "SELECT 1 FROM schema.table_name WHERE column1=structure_id1" this query for data validation.
There is no more simple a query that involve records on a single,table.
Please suggest is there any other ways to validate this kind of queries which will improve the overall performance.
Abandon procedural logic and embrace the declarative set oriented nature of SQL.
David J.
