f2s_table_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_table_hint_optimization_state of {FileNumber} to {variable}
get_attribute f2s_table_hint_optimization_state of {FileNumber} to {variable}
Parameter |
Description |
|---|---|
FileNumber |
Number of the file (filename.File_Number) |
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 table. 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.
f2s_default_hints: using the default for the server f2s_no_hints: turn hints off f2s_force_hints: turn hints 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
integer iHints
open Customer
Get_Attribute f2s_table_hint_optimization_state of Customer.File_Number to iHints
set_attribute
open Customer
Set_Attribute f2s_table_hint_optimization_state of Customer.File_Number to f2s_no_hints
Replaces¶
NATIVE_OPTIMIZATION using TABLE