Optimizing query for large number of rows in mysql

ALTER TABLE tbl_content ADD INDEX idx_state (state);
ALTER TABLE tbl_content ADD INDEX idx_catid (catid);
ALTER TABLE tbl_content ADD INDEX idx_section (sectionid);
ALTER TABLE tbl_content ADD INDEX idx_publish (publish_up);
ALTER TABLE tbl_content ADD INDEX idx_state_catid_publish (state, catid, publish_up);

Source:

https://dba.stackexchange.com/questions/93216/optimizing-query-for-large-number-of-rows-in-mysql

Article ID: 19
Created On: Wed, Sep 9, 2020 at 4:01 AM
Last Updated On: Wed, Sep 9, 2020 at 4:27 AM
Authored by: Saeed Nobakht [[email protected]]

Online URL: https://www.navel.ir/article/optimizing-query-for-large-number-of-rows-in-mysql-19.html