Laravel MySQL Use Index Scope is a super simple package that allows for use MySQL USE INDEX and FORCE INDEX statements. Simply reference the required trait in your model: Model: use VPominchuk\ModelUseIndex; class MyModel extends Model { use ModelUseIndex; }
Database table structure: You need to create a named index with required name.
Force MySQL to use an index if it possible.
I am a highly results-driven professional with 12+ years of collective experience in the grounds of web application development especially in laravel, native android application development in java, and desktop application development in the dot net framework.