Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to restrict default ROWCOUNT (number of rows) in Table View Query

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
Comments
-
Upvote. I would like the ability to set result set row count in tabular views.
0