Performance Considerations for SQL Statement Hints

Well researched and planned SQL statement hints can result in significantly better query performance. However, hints can also negatively affect performance if they result in a suboptimal processing plan.

Follow these guidelines to create hints to optimize query performance:

• Only add hints to a semantic model after you've tried to improve performance in the following ways:

  • Adding physical indexes or other physical changes to the Oracle Database.

  • Making modeling changes within the server.

• Avoid creating hints for physical table and join objects that are queried often. If you drop or rename a physical object that's associated with a hint, you must also update the hints accordingly.