Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 10 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Ability to restrict default ROWCOUNT (number of rows) in Table View Query

Mohit Shimpi-Oracle
Rank 4 - Community Specialist
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
Tagged:
2