> > > Given it seems most DBs have a default index (see Postgres, etc.), I tend > to lean toward having one, but that's me... >
I'm for it too. Would be nice to enforce the setting is globally uniform to avoid the per-node problem. Or add a keyspace option. For users replaying <5 DDLs this would just require they set the default index to 2i. This is not a headache, it's a one-off action that can be clearly expressed in NEWS. It acts as a deprecation warning too. This prevents new uneducated users from creating the unintended index, it supports existing users, and it does not present SAI as the battle-tested default. Agree with the poll, there's a number of different PoVs here already. I'm not fond of the LOCAL addition, I appreciate what it informs, but it's just not important enough IMHO (folk should be reading up on the index type).
