title: Suggest Plan to Query Optimiser
body: <p>There are times I can use force index option to use particular index on a query to make the query faster. </p>
  
  <p>Then after some times the data in that table may change. And the force index which I used may not be the right index search for that query.</p>
  
  <p>My questions are</p>
  
  <ul>
  <li><p>Is there anyway to suggest the Query Optimiser to use a force index as a possible option during its plan generation. If it is a slow plan on using the forced index then it can use normal query planning. </p></li>
  <li><p>Or Else Is there anyway to edit the Code of MySql/PSQL to suggest the Optimiser to use a force index as a possible option during its plan generation.</p></li>
  </ul>
  
  <p><strong>Additional Info:</strong> I wanted to add my plan to the optimiser plan list( that Optimiser already created many plan for a query). So that while choosing the best plan for a query I wanted the optimiser to consider my plan also. If this way is possible then the optimiser need not consider force index every time. It can keep the force index as a possible option to the plan generation</p>
  
  <p>I tried to make the question clear as of my knowledge. If anyone couldn't understand comment your queries.</p>