all-things-risingwave

Will all table data be scanned for batch query of materialized view with 'select * from t;' and 'select * from t limit 10;'? Is there an optimization plan for slow response with large data?

I am concerned about the performance of batch queries on materialized views when using 'select * from t;' and 'select * from t limit 10;'. The response time is slow with large data sets. Is there an optimization plan for this issue?

ji

jie

Asked on Dec 29, 2022

  • When using select * from t;, all table data will be scanned.
  • The limit clause will early exit if it has encountered the specified number of rows, but it may still scan all the content.
  • There may be optimization plans to improve the performance of batch queries on materialized views with large data sets.
  • The version being used is v0.1.13.
Dec 29, 2022Edited by