特殊的MySQL查询优化是否适用于PHP？

Question

I'm trying to optimize a query used in a PHP script, and I've been trying to figure out if PHP accepts index hints in SQL statements, but I haven't been able to find documentation on it anywhere.

This is what the format of the query is:

Select a.columnName, b.columnName from tableName as a FORCE
INDEX(indexName) Inner Join tableName as b 
On a.columnName = b.columnName
Where a.columnName =..

Please forgive omitting the actual query, as I'm more concerned with trying to figure out if PHP allows queries like this rather than the data itself. I had to add the forced index to my query to make the query perform faster as the initial table it pulls from is rather large. Can anyone help me with figuring this out or point in the direction of some documentation on it?

For those wondering, I've already looked at the documentation on the MySQL pages, so I'm not really sure what else to look at.

Answer 1

This will work, since PHP is just forwarding the SQL query direcly to the DBMS. So what works on the DBMS (e.g. MySql) will work with PHP.

e.g. with mysqli::query for MySQL