Breaking News: Grepper is joining You.com. Read the official announcement!

mysql force query to use index

Friendly Hawk answered on April 12, 2022 Popularity 9/10 Helpfulness 10/10

answer mysql force query to use index

related Force Index in MySql

mysql force query to use index

Comment

/* if mysql is dumb and using wrong index you can force it to use
the one you want like so:*/
select name from users USE INDEX (index4) where name='hello';

Popularity 9/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: mysql sql

Link to this answer
Share Copy Link

Contributed on Apr 12 2022

Friendly Hawk

0 Answers Avg Quality 2/10

Closely Related Answers

Force Index in MySql

Comment

EXPLAIN SELECT 
    productName, buyPrice
FROM
    products 
FORCE INDEX (idx_buyprice)
WHERE
    buyPrice BETWEEN 10 AND 80
ORDER BY buyPrice;
Code language: SQL (Structured Query Language) (sql)

Popularity 9/10 Helpfulness 5/10 Language sql

Source: www.mysqltutorial.org

Tags: sql mysql

Link to this answer
Share Copy Link