This. I would also consider adding CREATE LEGACY INDEX syntax as an alias for today’s CREATE INDEX, the latter to be deprecated and (in very distant future) removed.
> On 12 May 2023, at 13:14, Benedict <bened...@apache.org> wrote: > > This creates huge headaches for everyone successfully using 2i today though, > and SAI *is not* guaranteed to perform as well or better - it has a very > different performance profile. > > I think we should deprecate CREATE INDEX, and introduce new syntax CREATE > LOCAL INDEX to make clear that this is not a global index, and that this > should require the USING syntax to avoid this problem in future. > > We should report warnings to the client when CREATE INDEX is used, indicating > it is deprecated.