f2s_hint_optimization_state¶
Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers
ONLY USE THIS WHEN INSTRUCTED TO BY THE MERTECH SUPPORT STAFF.
Syntax
set_attribute f2s_hint_optimization_state of {DriverID} to {variable}
get_attribute f2s_hint_optimization_state of {DriverID} to {variable}
Parameter |
Description |
|---|---|
DriverID |
The ID of the driver for which this applies. In most cases, you should use _f2s_ActiveDriverID. |
variable |
f2s_default_hints (-1), f2s_no_hints (0) and f2s_force_hints(1) |
Description
This only affects database access when using DataFlex commands (find, save, datadictionary actions, ect).
This allows the user to turn on/off index hints on the server. Setting this attribute to f2s_default_hints will cause the server to use the default settings for hints. For Microsoft SQL Server, hints are off by default. However, in Oracle, they are on.
When to Use
ONLY USE THIS WHEN INSTRUCTED TO BY THE MERTECH SUPPORT STAFF. This not only effects how a query is run, but what rows are locked and when, where and what data is returned.
Examples
get_attribute
Get_Attribute f2s_server_hint_optimization_state of _f2s_ActiveDriverID to bValue1
set_attribute
Set_Attribute f2s_server_hint_optimization_state of _f2s_ActiveDriverID to f2s_force_hints
Replaces: NATIVE_OPTIMIZATION using SERVER