Laravel MySQL Use Index Scope
A super simple package allowing for use MySQL USE INDEX and FORCE INDEX statements.
Requirements
- PHP
^7.4 | ^8.0 - Laravel 6, 7 and 8
Installation
composer require vpominchuk/laravel-mysql-use-index-scope
Usage
Simply reference the required trait in your model:
Model:
use VPominchuk\ModelUseIndex;
class MyModel extends Model
{
use ModelUseIndex;
}
Anywhere in the code:
$builder = MyModel::where('name', $name)->where('age', $age)->
useIndex($indexName)->...
Database table structure:
You need to create a named index with required name. For example:
Laravel Migration:
$table->index(['name', 'age'], 'user_age_index');
Available methods
useIndex($indexName)
Tells MySQL to use an index if it possible.
forceIndex($indexName)
Force MySQL to use an index if it possible.
ignoreIndex($indexName)
Ask MySQL to ignore an index if it possible.
Security
If you discover any security related issues, please use the issue tracker.
Credits
License
The MIT License (MIT). Please see License File for more information.
12 Jan 17, 2022
16 Nov 30, 2022
3 Oct 9, 2022
3 Dec 16, 2021
1 Jan 9, 2022
1 Feb 5, 2022
4 Oct 2, 2022
17 Nov 29, 2022
3 Dec 1, 2021
7 Jul 14, 2022
2 Aug 27, 2022
441 Jan 5, 2023
3 Sep 10, 2022
4 Apr 28, 2022
2 Dec 7, 2021
591 Dec 17, 2022
48 Dec 29, 2022
149 Nov 11, 2022
931 Dec 24, 2022