Query Folding

Using query folding, the connector can delegate the processing of certain operations to the server instead of performing them locally on the client machine. The Simba PayPal JDBC Connector supports query folding for specific columns. When you run a query that filters on columns for which folding is supported, the connector attempts to optimize connector performance by delegating the comparison operation to the server.

For information about the columns that support query folding and examples of how to design queries that make use of query folding, see "Design Queries that Use Query Folding" in Best Practices.

Related topics

• Features
• Best Practices