across can be a very effective method of performing tactical queries. The pros and cons of using macros to perform tactical queries in various applications and application workloads are described in detail elsewhere:
• See Database Design for further information about using macros to perform tactical queries.
• See SQL Data Manipulation Language, for a comparison of the relative efficiency of macros and stored procedures for performing tactical queries.