@Stima_Livingpresent this is essentially another way to set a LIMIT statement for the query. Normally for Table Visuals the limit starts at 100, and then if you clear out that limit it will use a the default “Maximum number of rows to fetch” limit of 5000 so that you don’t fetch the entire set of rows from the table. Your query will scan the entire table, but the result set will be limited to either this value or possibly the limit that sets below the Visual shelves if you’re using a table visual. Normally you don’t want to set this limit very high as it will slow down performance, and also it may be difficult to digest that many data points in a single Visual.
This article also has more details on limits inside of Arcadia if you’re interested.