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