Re: [DISCUSS] Index selection syntax for CASSANDRA-18112

2024-12-22 Thread guo Maxwell
Wrong typing, it is DML not DDL ~~~😅 guo Maxwell 于2024年12月23日周一 11:56写道: > Thanks Caleb for bringing it up. > > When I opened this issue, I originally wanted to propose the following > syntax: > 1、When we want to force the selection of certain indexes: > SELECT ...USE INDEX (ks.idx1, ks.idx2

Re: [DISCUSS] Index selection syntax for CASSANDRA-18112

2024-12-22 Thread guo Maxwell
Thanks Caleb for bringing it up. When I opened this issue, I originally wanted to propose the following syntax: 1、When we want to force the selection of certain indexes: SELECT ...USE INDEX (ks.idx1, ks.idx2) ... FROM ...WHERE ... or SELECT .../*+ USE INDEX (ks.idx1, ks.idx2)*/ ... FROM