PHPackages                             vpominchuk/laravel-mysql-use-index-scope - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. vpominchuk/laravel-mysql-use-index-scope

ActiveLibrary[Database & ORM](/categories/database)

vpominchuk/laravel-mysql-use-index-scope
========================================

A super simple package allowing for use MySQL `USE INDEX` and `FORCE INDEX` statements

v1.0.8(5mo ago)41569.9k—1.6%7[1 issues](https://github.com/vpominchuk/laravel-mysql-use-index-scope/issues)MITPHPPHP ^7.4|^8.0

Since Sep 12Pushed 5mo ago1 watchersCompare

[ Source](https://github.com/vpominchuk/laravel-mysql-use-index-scope)[ Packagist](https://packagist.org/packages/vpominchuk/laravel-mysql-use-index-scope)[ Docs](https://github.com/vpominchuk/laravel-mysql-use-index-scope)[ RSS](/packages/vpominchuk-laravel-mysql-use-index-scope/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (7)Dependencies (1)Versions (9)Used By (0)

[![](https://camo.githubusercontent.com/16a2637475322fb78bd7aaea2c7058f2bc3d5807bba47e6bae354daa4624c030/68747470733a2f2f62616e6e6572732e6265796f6e64636f2e64652f4c61726176656c2532304d7953514c253230555345253230494e4445582532304d6f64656c25323053636f70652e706e673f7468656d653d6c69676874267061636b6167654d616e616765723d636f6d706f7365722b72657175697265267061636b6167654e616d653d76706f6d696e6368756b2532466c61726176656c2d6d7973716c2d7573652d696e6465782d73636f7065267061747465726e3d74657874757265267374796c653d7374796c655f31266465736372697074696f6e3d416c6c6f77696e672b666f722b7573652b4d7953514c2b5553452b494e4445582b616e642b464f5243452b494e4445582b73746174656d656e7473266d643d312673686f7757617465726d61726b3d3026666f6e7453697a653d313030707826696d616765733d68747470732533412532462532466c61726176656c2e636f6d253246696d672532466c6f676f6d61726b2e6d696e2e737667)](https://camo.githubusercontent.com/16a2637475322fb78bd7aaea2c7058f2bc3d5807bba47e6bae354daa4624c030/68747470733a2f2f62616e6e6572732e6265796f6e64636f2e64652f4c61726176656c2532304d7953514c253230555345253230494e4445582532304d6f64656c25323053636f70652e706e673f7468656d653d6c69676874267061636b6167654d616e616765723d636f6d706f7365722b72657175697265267061636b6167654e616d653d76706f6d696e6368756b2532466c61726176656c2d6d7973716c2d7573652d696e6465782d73636f7065267061747465726e3d74657874757265267374796c653d7374796c655f31266465736372697074696f6e3d416c6c6f77696e672b666f722b7573652b4d7953514c2b5553452b494e4445582b616e642b464f5243452b494e4445582b73746174656d656e7473266d643d312673686f7757617465726d61726b3d3026666f6e7453697a653d313030707826696d616765733d68747470732533412532462532466c61726176656c2e636f6d253246696d672532466c6f676f6d61726b2e6d696e2e737667)

[![Latest Version on Packagist](https://camo.githubusercontent.com/659e2e456f68cf2271ac6e0f98824bc8d21d0a65b3416dfd555f3f5672084dc9/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f76706f6d696e6368756b2f6c61726176656c2d6d7973716c2d7573652d696e6465782d73636f70652e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/vpominchuk/laravel-mysql-use-index-scope)[![Software License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](LICENSE)[![Total Downloads](https://camo.githubusercontent.com/36638ef61a1e6a9344662cf834e1c2d0eec6728e44ad554d9660c10acb471f77/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f76706f6d696e6368756b2f6c61726176656c2d6d7973716c2d7573652d696e6465782d73636f70652e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/vpominchuk/laravel-mysql-use-index-scope)

Laravel MySQL Use Index Scope
=============================

[](#laravel-mysql-use-index-scope)

A super simple package allowing for use MySQL `USE INDEX` and `FORCE INDEX` statements.

Requirements
------------

[](#requirements)

- PHP `^7.4 | ^8.0`
- Laravel 6, 7, 8, 9, 10, 11, and 12

Installation
------------

[](#installation)

`composer require vpominchuk/laravel-mysql-use-index-scope`

Usage
-----

[](#usage)

Simply reference the required trait in your model:

### Model:

[](#model)

```
    use VPominchuk\ModelUseIndex;

    class MyModel extends Model
    {
        use ModelUseIndex;
    }
```

### Anywhere in the code:

[](#anywhere-in-the-code)

```
    $builder = MyModel::where('name', $name)->where('age', $age)->
        useIndex($indexName)->...
```

### Database table structure:

[](#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
-----------------

[](#available-methods)

#### `useIndex($indexName)`

[](#useindexindexname)

Tells MySQL to use an index if it possible.

#### `forceIndex($indexName)`

[](#forceindexindexname)

Force MySQL to use an index if it possible.

#### `ignoreIndex($indexName)`

[](#ignoreindexindexname)

Ask MySQL to ignore an index if it possible.

Security
--------

[](#security)

If you discover any security related issues, please use the issue tracker.

Credits
-------

[](#credits)

- [Vasyl Pominchuk](https://github.com/vpominchuk)

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE) for more information.

###  Health Score

53

—

FairBetter than 97% of packages

Maintenance69

Regular maintenance activity

Popularity49

Moderate usage in the ecosystem

Community16

Small or concentrated contributor base

Maturity61

Established project with proven stability

 Bus Factor1

Top contributor holds 73.7% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~219 days

Recently: every ~277 days

Total

8

Last Release

175d ago

PHP version history (2 changes)v1.0.0PHP ^7.4 | ^8.0

v1.0.7PHP ^7.4|^8.0

### Community

Maintainers

![](https://www.gravatar.com/avatar/0698741e2b6a33a9bc4b38ec28db9b253910a76eb0a890e9d45a5e9debe91e61?d=identicon)[vpominchuk](/maintainers/vpominchuk)

---

Top Contributors

[![vpominchuk](https://avatars.githubusercontent.com/u/4194395?v=4)](https://github.com/vpominchuk "vpominchuk (14 commits)")[![AJenbo](https://avatars.githubusercontent.com/u/204594?v=4)](https://github.com/AJenbo "AJenbo (2 commits)")[![dkmonaghan](https://avatars.githubusercontent.com/u/920215?v=4)](https://github.com/dkmonaghan "dkmonaghan (1 commits)")[![ijalnasution](https://avatars.githubusercontent.com/u/17308059?v=4)](https://github.com/ijalnasution "ijalnasution (1 commits)")[![issakujitsuk](https://avatars.githubusercontent.com/u/12658523?v=4)](https://github.com/issakujitsuk "issakujitsuk (1 commits)")

---

Tags

laravellaravel-eloquentlaravel-eloquent-modelslaravel-frameworkmysqlphplaravellaravel mysqllaravel mysql use indexlaravel mysql force index

### Embed Badge

![Health badge](/badges/vpominchuk-laravel-mysql-use-index-scope/health.svg)

```
[![Health](https://phpackages.com/badges/vpominchuk-laravel-mysql-use-index-scope/health.svg)](https://phpackages.com/packages/vpominchuk-laravel-mysql-use-index-scope)
```

###  Alternatives

[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[watson/validating

Eloquent model validating trait.

9723.3M47](/packages/watson-validating)[cybercog/laravel-love

Make Laravel Eloquent models reactable with any type of emotions in a minutes!

1.2k302.7k1](/packages/cybercog-laravel-love)[cviebrock/eloquent-taggable

Easy ability to tag your Eloquent models in Laravel.

567694.8k3](/packages/cviebrock-eloquent-taggable)[clickbar/laravel-magellan

This package provides functionality for working with the postgis extension in Laravel.

423715.4k1](/packages/clickbar-laravel-magellan)[reedware/laravel-relation-joins

Adds the ability to join on a relationship by name.

2121.2M13](/packages/reedware-laravel-relation-joins)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)