Specifies the maximum number of rows the provider returns when a query does not include aggregation or grouping.

データ型

string

デフォルト値

"-1"

解説

This property controls the number of rows the connector returns when running a query without aggregation or GROUP BY clauses.

Set this property to a positive integer to limit the number of rows returned. Set it to -1 to return all available rows.

Limiting rows can improve performance when previewing data in design-time environments such as business intelligence tools or query builders.

Use this property when working with large datasets and you want to avoid loading the entire result set during development or metadata exploration.