We have some a real-time use case to analyze a DB based dataset that has 100Million+ (and growing) rows. While the metrics like sum & count work like a charm, the challenge is when the table view is loaded for detailed view. We would like some ability to restrict the rows in table view to say fetch FIRST 500 rows as default and then if user wants they can see more data if required.

The current query that is generated by DV is limiting the ROWCOUNT < 500001. This is really too SLOW especially when we have large datasets with 100+ million rows