skip to Main Content

Index not hit in mysql

When I select all columns, the indexing does not work, but if I select just a few columns, it does. mysql> explain SELECT * FROM fatura USE INDEX (datapago_serv_pago) WHERE id_servidor = 10 AND pago = '1' AND data_pago <=…

VIEW QUESTION
Back To Top
Search