There are a few configuration options for the server that can affect how you write your code.
Settings for InterSystems SQL
This section discusses some of the most important settings that affect the behavior of InterSystems SQL.
This setting (which is on by default) ensures the best out-of-the-box performance for a wide set of use cases. Specifically, Adaptive Mode controls Runtime Plan Choice (RTPC), parallel processing, and automatically runs TUNE TABLE to optimize the efficiency of query execution. The individual features that Adaptive Mode governs cannot be controlled independently without turning Adaptive Mode off.
For details, see AdaptiveMode in the Configuration Parameter File Reference.
Retain Cached Query Source
This setting specifies whether to save the routine and INT code that InterSystems IRIS generates when you execute any InterSystems SQL except for embedded SQL. In all cases, the generated OBJ is kept. By default, the routine and INT code is not kept.
The query results are not stored in the cache.
For details, see SaveMAC in the Configuration Parameter File Reference.
This setting specifies the default schema name to use when creating or deleting tables that do not have a specified schema. It is also used for other DDL operations, such as creating or deleting a view, trigger, or stored procedure.
For details, see DefaultSchema in the Configuration Parameter File Reference.
For more information, see Schema Name.
Delimited Identifier Support
This setting controls how InterSystems SQL treats characters contained within a pair of double quotes.
If you enable support for delimited identifiers (the default), you can use double quotes around the names of fields, which enables you to refer to fields whose names are not regular identifiers. Such fields might, for example, use SQL reserved words as names.
If you disable support for delimited identifiers, characters within double quotes are treated as string literals, and it is not possible to refer to fields whose names are not regular identifiers.
You can set delimited identifier support system-wide using the SET OPTION command with the SUPPORT_DELIMITED_IDENTIFIERS keyword or by using the $SYSTEM.SQL.Util.SetOption()Opens in a new tab method DelimitedIdentifiers option. To determine the current setting, call $SYSTEM.SQL.CurrentSettings()Opens in a new tab.
For more information, see Delimited Identifiers.