Query block example: Sales count

In this query, the query block SELECT COUNT(*) FROM sales is sent to Informix® Warehouse Accelerator for acceleration.

The query block SELECT COUNT(*) FROM systables does not qualify for acceleration.

SELECT COUNT(*) FROM sales UNION ALL SELECT COUNT(*) FROM systables; 

In this example, both SELECT query blocks are sent to Informix Warehouse Accelerator for processing. Each query block is sent separately.

SELECT COUNT(*) FROM sales UNION ALL SELECT COUNT(*) FROM sales_returns;