How to index a column using Drift?

[TinhHuynh]

Hi, we have tables generated by Drift. But now we want to index some columns for faster DB queries.
How do we do that?

[simolus3]

Hi, at the moment this is not directly possible with a high-level Dart API. You can write the CREATE INDEX statement manually and add it to your database like this:

  @override
  List<DatabaseSchemaEntity> get allSchemaEntities => [
        ...super.allSchemaEntities,
        _myIndex,
      ];

  final Index _myIndex =
      Index('my_index', 'CREATE INDEX my_index ON foo (bar, baz)');

Added like this, the index will be created automatically when the database is created. You can also create it manually with migrator.create(_myIndex) in a schema migration.