Hints

SODA lets you pass SQL hints to the underlying SQL statements generated for SODA operations.

The hint text uses the same format as in SQL: it is the text that would appear between /*+ and */ in a SQL statement, but passed without the comment delimiters.

This can be useful, for example, to influence index selection with INDEX or to monitor execution with MONITOR.

SODA lets you pass SQL hints to the underlying SQL statements generated for SODA operations.

The hint text uses the same format as in SQL: it is the text that would appear between /*+ and */ in a SQL statement, but passed without the comment delimiters.

This can be useful, for example, to influence index selection with INDEX or to monitor execution with MONITOR.

For details on how to pass hints in a specific SODA implementation, refer to the documentation for that implemenation.

See Also:

• Monitoring Database Operations in Oracle Database SQL Tuning Guide for complete information about monitoring database operations
• MONITOR and NO_MONITOR Hints in Oracle Database SQL Tuning Guide for information about the syntax and behavior of SQL hints MONITOR and NO_MONITOR