I am considering a data structure for our internal application that would require having an index on 10 fields all of which are strings.
Is there a way to make them each an index but not include the empty strings in the indexing.
In the past we treated each as a record and only inserted them if they had values. Now I want to consider a document store type of database that would have all data stored together with 10 strings for indexed lookup.
I am new to Tarantool but have extensive experience with relational databases. My effort would allow my department to consider switching to this very promising alternative.
Thanks for any help.
Severin