Skip to content
Advertisement

Tag: query-optimization

What could be the possible drawbacks of using force index clause in mysql query? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 1 year ago. Improve this question Sample Example – SELECT * FROM table_name FORCE INDEX (index_list) WHERE condition; Without using force index, mysql’s query optimiser decides

Advertisement