my table has (among others) three columns, which are unique blobs.
So I made the first column the partition key and created two sasi
indices for the two other columns.
After inserting ca 90m records I'm not able to query a bunch of rows
(sending 10000 selects to the cluster) using only a sasi index. After a
few seconds I get timeouts.
I have read the documents about the sasi index but I don't get why this
happens. Is this because I don't include the partition key in the query?
I thought sasi index is globally held, in contrast to the normal
thanks for helping,