NATIVE_OPTIMIZATION¶
Applies to: ORAFlex SQLFlex
Allows user to turn off the use of index hints on the native server. Setting this command to DEFAULT will cause the server to use the default settings for hints. Hints are off by default in Microsoft SQL Server but are on in Oracle. Care should be taken with changing the default, and should only be used if the diagnostics tool for your server indicates performance problems with the type of queries that are being generated. Note that this can be turned off or on for the whole server or just for a specific table.
DEFAULT - The specified server’s default settings USE_INDEXHINT - All Index hints will be used NO_INDEXHINT - No index hints will be used
Syntax
NATIVE_OPTIMIZATION of {scopeLevel} {variable} to {constant}
Parameter |
Description |
|---|---|
scopeLevel |
TABLE or SERVER. Indicates the scope of the setting |
variable |
Either the name of the server or of the table |
constant |
DEFAULT, USE_INDEXHINT, or NO_INDEXHINT |
Example
NATIVE_OPTIMIZATION of SERVER "localhost" to USE_INDEXHINT