We've had a few issues around indexes, so rather than making isolated decisions without the all-up context we are creating an issue to take a holistic look at what we do.

Can you put together a summary of how we handle indexes and what needs to change. This should include the things discussed in:

• RevEng: Sqlite: Indexes for PK are scaffolded wrongly #3642
• Handle redundant PK indexes in RelationalScaffoldingModelFactory #3664