Pushdown Optimization

You can optimize connector performance by restricting the scope of a query to include the required columns only.

The connector supports both filter and aggregation pushdown:

• Filter pushdown applies the filter to the server, rather than retrieving all rows from the server and then applying the filter.
• Aggregation pushdown applies the aggregation to the server, rather than retrieving all rows from the server and then applying the aggregation.

For example, to perform a filter pushdown, use a query like the following:

SELECT "T1_1"."Column1" FROM (SELECT "OneHundredRecords"."Column1" FROM "OneHundredRecords") AS "T1_1" WHERE "Column1" = '10'

As another example, to perform an aggregation pushdown, use a query like the following:

SELECT sum ("Column1") FROM ( SELECT "OneHundredRecords"."Column1" FROM "OneHundredRecords" )