Shulou(Shulou.com)06/01 Report--

Index hints can artificially tell the mysql optimizer how to complete select, such as forcing certain index (s) to go or ignoring certain index (s).

The specified index must have an index name.

Officially provided basic grammar:

index_hint:

USE {INDEX|KEY}

[FOR {JOIN|ORDER BY|GROUP BY}] ([index_list])

| IGNORE {INDEX|KEY}

[FOR {JOIN|ORDER BY|GROUP BY}] (index_list)

| FORCE {INDEX|KEY}

[FOR {JOIN|ORDER BY|GROUP BY}] (index_list)

where index_list is the index name.

Test table:

Author Weixin Official Accounts (continuously updated)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.