If you are sure , that you want to do LIKE , then you can go with SASI . https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html Hope this will help you .
On Wed, Jun 21, 2017 at 2:44 PM, web master <socketman2...@gmail.com> wrote: > I have this table > > CREATE TABLE users_by_username ( > username text PRIMARY KEY, > email text, > age int > ) > > I want to run query like the following > > select username from users where username LIKE 'shl%' LIMIT 10; > > > Always , I want to find only 10 username (Case insensitive) that start > with specific characters , How can I do it efficient? I want to read > minimum partitions and best performance > >
