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?
jie
Asked on Dec 29, 2022
select * from t;, all table data will be scanned.limit clause will early exit if it has encountered the specified number of rows, but it may still scan all the content.