title: optimize for and recompile hint in Oracle?
body: <p>Is there any hints in Oracle that works the same way as these SQL Server hints?</p>
  
  <p>Recompile: That a query is recompiled every time it's run (if execution plans should vary greatly depending on parameters). Would this be best compared to cursor_sharing in Oracle?</p>
  
  <p>Optimize for: When you want the plan to get optimized for a certain parameter even if a different one is used the first time the SQL is run? I guess maybe could be helped with cursor_sharing as well?</p>