I have the following table:
CREATE TABLE servers ( id uuid, hostname text, ip inet, dc text, db text, groups set<text>, windows boolean, PRIMARY KEY ((id, hostname, ip), dc) ) WITH CLUSTERING ORDER BY (dc ASC)
I want to filter on groups. How can I do this? Do I need an Index? I don't want to use allow filtering option. Is there a way I can improve the schema?