ignoreIndex method
Applies an IGNORE INDEX hint (MySQL/MariaDB only).
This hint tells the database optimizer to ignore a specific index for the query.
Example:
final usersIgnoringIndex = await context.query<User>()
.ignoreIndex(['idx_users_old_data'])
.where('createdAt', '<', DateTime(2020))
.get();
Implementation
Query<T> ignoreIndex(List<String> indexes) =>
_addIndexHint(IndexHint(IndexHintType.ignore, indexes));