Download the PHP package shaburov/laravel-mysql-index-hints-scope without Composer
On this page you can find all versions of the php package shaburov/laravel-mysql-index-hints-scope. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download shaburov/laravel-mysql-index-hints-scope
More information about shaburov/laravel-mysql-index-hints-scope
Files in shaburov/laravel-mysql-index-hints-scope
Package laravel-mysql-index-hints-scope
Short Description Index Hints for laravel https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
License MIT
Informations about the package laravel-mysql-index-hints-scope
Laravel mysql index hints scope
Simple library for mysql index hints and optimisations (USE INDEX, FORCE INDEX, IGNORE INDEX)
requires
- php: ^7.4|^8.0|^8.1|^8.2|^8.3
- doctrine/dbal: ^3.0
- illuminate/database: ^8.0|^9.0|^10.0|^v11.0
- illuminate/support: ^8.0|^9.0|^10.0|^v11.0
Installation
composer require shaburov/laravel-mysql-index-hints-scope
How it's use
Extended class Blueprint
The following methods have been added to the Blueprint class: dropIndexIfExists,hasIndex
Use trait
Functions
If there is no index, then no error will occur.
Examples
Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, described in Section 8.9.3, “Optimizer Hints”. Index and optimizer hints may be used separately or together.
Index hints apply only to SELECT and UPDATE statements.
Index hints are specified following a table name. (For the general syntax for specifying tables in a SELECT statement, see Section 13.2.9.2, “JOIN Clause”.) The syntax for referring to an individual table, including index hints, looks like this:
Offical MySQL documentation
Index Hints https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
All versions of laravel-mysql-index-hints-scope with dependencies
illuminate/database Version ^v11.0
illuminate/support Version ^v11.0
doctrine/dbal Version ^3.0