select * reads all of the data from the cluster, obviously it would be bad if you'll run a single query and expect it to return 'fast'. The best way is to divide the data set into chunks which will be selected by the range ownership per node, so you'll be able to query in parallel the entire cluster and maximize the parallelism.
If needed, I can provide an example for this On Tue, Apr 26, 2022 at 3:48 PM 18624049226 <18624049...@163.com> wrote: > We have a business scenario. We must execute the following statement: > > select * from tbl; > > This CQL has no WHERE condition. > > What I want to ask is that if the data in this table is more than one > million or more, what methods or parameters can improve the performance of > this CQL? >
