I’m developing a project that is likely to end up having a large number of separate sub-projects, each with its own data.
I’m looking at the CREATE INDEX syntax, and thinking that using something like:
CREATE INDEX my_index ON my_bucket ( … ) WHERE _pid = 10
for example might be a way to go to create indexes just on the project wtih an ID of 10.
What I’m wondering is whether the correct index will always be selected if _pid = 10 is provided. My assumption is that it should be, I just wanted to ask.