Oracle Analytics Cloud and Server Idea Lab

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

Under Review
11
Views
0
Comments
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
2 votes

Under Oracle Review · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.