You can create an index in MotherDuck using standard DuckDB SQL syntax, for example: LBKSCREATE INDEX idx_user_id ON users(id);LBKSHowever, while the syntax is supported and the index will be created, indexes in MotherDuck do not currently provide query acceleration—they are only used for enforcing constraints like UNIQUE or PRIMARY KEY, not for speeding up SELECT queries. Queries will still use sequential scans rather than index scans in MotherDuck, even if an index exists. For more, see the MotherDuck CREATE INDEX documentation.Would you like more detail on how indexes behave in MotherDuck or how to use them for constraints?Sources:
- MotherDuck CREATE INDEX documentation
💡Hint: Mention RunLLM in the thread for followups.