Performance tuning

We have 250M records in a table and have created a pin on top the same table. It's taking more than 2 seconds to return the data in UI. But our client expecting data with in 2 seconds.

  • Around 100 fields in the table.
  • Created only one worksheet
  • More than 50 field's Index type is Default.
  • Attribution dimension is Yes for all the fields (Can we set this off since we have only one table ?)

We mostly use around 8-10 filters only in UI. so, If we turn off index for all the fields except the filter fields ,then the performance would improve?

Pls help us on this.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 2 yrs agoLast active
  • 1Replies
  • 513Views
  • 2 Following