Alphabetical List of Options

Descriptions of general, Transact-SQL compatibility, and Interactive SQL database options. Some option names are followed by a class indicator in square brackets.

• AGGREGATION_PREFERENCE Option
  Controls the choice of algorithms for processing an aggregate.
• ALLOW_NULLS_BY_DEFAULT Option [TSQL]
  Controls whether new columns created without specifying either NULL or NOT NULL are allowed to contain NULL values.
• ANSI_CLOSE_CURSORS_ON_ROLLBACK Option [TSQL]
  Controls whether cursors that were opened WITH HOLD are closed when a ROLLBACK is performed.
• ANSI_PERMISSIONS Option [TSQL]
  Controls permissions checking for DELETE and UPDATE statements.
• ANSINULL Option [TSQL]
  Controls the interpretation of using = and != with NULL.
• ANSI_SUBSTRING Option [TSQL]
  Controls the behavior of the SUBSTRING (SUBSTR) function when negative values are provided for the start or length parameters.
• ANSI_UPDATE_CONSTRAINTS Option
  Controls the range of updates that are permitted.
• ALLOW_READ_CLIENT_FILE Option
  Enables client-side data transfer.
• APPEND_LOAD Option
  Helps reduce space usage from versioned pages.
• ASE_BINARY_DISPLAY Option
  Specifies that the display of Sybase IQ binary columns is consistent with the display of Adaptive Server Enterprise binary columns.
• ASE_FUNCTION_BEHAVIOR Option
  Specifies that output of Sybase IQ functions, including INTTOHEX and HEXTOINT, is consistent with the output of Adaptive Server Enterprise functions.
• AUDITING Option [database]
  Enables and disables auditing in the database.
• BIT_VECTOR_PINNABLE_CACHE_PERCENT Option
  Maximum percentage of a user’s temp memory that a persistent bit-vector object can pin.
• BLOCKING Option
  Controls the behavior in response to locking conflicts.
• BT_PREFETCH_MAX_MISS Option
  Controls the way Sybase IQ determines whether to continue prefetching B-tree pages for a given query.
• BT_PREFETCH_SIZE Option
  Restricts the size of the read-ahead buffer for the High_Group B-tree.
• BTREE_PAGE_SPLIT_PAD_PERCENT Option
  Determines per-page fill factor during page splits for B-Tree structures.
• CACHE_PARTITIONS Option
  Sets the number of partitions to be used for the main and temporary buffer caches.
• CHAINED Option [TSQL]
  Controls transaction mode in the absence of a BEGIN TRANSACTION statement.
• CHECKPOINT_TIME Option
  Set the maximum length of time, in minutes, that the database server runs without doing a checkpoint.
• CIS_ROWSET_SIZE Option
  Sets the number of rows that are returned from remote servers for each fetch.
• CLOSE_ON_ENDTRANS Option [TSQL]
  Controls closing of cursors at the end of a transaction.
• CONTINUE_AFTER_RAISERROR Option [TSQL]
  Controls behavior following a RAISERROR statement.
• CONVERSION_ERROR Option [TSQL]
  Controls reporting of data type conversion failures on fetching information from the database.
• CONVERSION_MODE Option
  Restricts implicit conversion between binary data types (BINARY, VARBINARY, and LONG BINARY) and other non-binary data types (BIT, TINYINT, SMALLINT, INT, UNSIGNED INT, BIGINT, UNSIGNED BIGINT, CHAR, VARCHAR, and LONG VARCHAR) on various operations.
• CONVERT_VARCHAR_TO_1242 Option
  Converts pre-version 12.4.2 VARCHAR data to compressed format.
• COOPERATIVE_COMMIT_TIMEOUT Option
  Governs when a COMMIT entry in the transaction log is written to disk.
• COOPERATIVE_COMMITS Option
  Controls when commits are written to disk.
• CURSOR_WINDOW_ROWS Option
  Defines the number of cursor rows to buffer.
• DATE_FIRST_DAY_OF_WEEK Option
  Determines the first day of the week.
• DATE_FORMAT Option
  Sets the format used for dates retrieved from the database.
• DATE_ORDER Option
  Controls the interpretation of date formats.
• DBCC_LOG_PROGRESS Option
  Reports the progress of the sp_iqcheckdb system stored procedure.
• DBCC_PINNABLE_CACHE_PERCENT Option
  Controls the percent of the cache used by the sp_iqcheckdb system stored procedure.
• DEBUG_MESSAGES Option
  Controls whether or not MESSAGE statements that include a DEBUG ONLY clause are executed.
• DEDICATED_TASK Option
  Dedicates a request handling task to handling requests from a single connection.
• DEFAULT_DBSPACE Option
  Changes the default dbspace where tables or join indexes are created.
• DEFAULT_DISK_STRIPING Option
  Sets the default disk striping value for all dbspaces.
• DEFAULT_HAVING_SELECTIVITY_PPM Option
  Provides default selectivity estimates to the optimizer for most HAVING clauses in parts per million.
• DEFAULT_ISQL_ENCODING Option [Interactive SQL]
  Specifies the code page used by READ and OUTPUT statements.
• DEFAULT_KB_PER_STRIPE Option
  Sets an upper threshold in KB on the amount to write to a stripe before write operations move on to the next stripe.
• DEFAULT_LIKE_MATCH_SELECTIVITY_PPM Option
  Provides default selectivity estimates (in parts per million) to the optimizer for most LIKE predicates.
• DEFAULT_LIKE_RANGE_SELECTIVITY_PPM Option
  Provides default selectivity estimates (in parts per million) to the optimizer for leading constant LIKE predicates.
• DEFAULT_PROXY_TABLE_ROW_COUNT Option
  Enables you to override the default estimate of the number of rows to return from a proxy table.
• DEFAULT_TABLE_UDF_ROW_COUNT Option
  Enables you to override the default estimate of the number of rows to return from a table UDF (either a C, C++, or Java table UDF).
• DELAYED_COMMIT_TIMEOUT Option
  Determines when the server returns control to an application following a COMMIT.
• DELAYED_COMMITS Option
  Determines when the server returns control to an application following a COMMIT.
• DISABLE_RI_CHECK Option
  Allows load, insert, update, or delete operations to bypass the referential integrity check, improving performance.
• DIVIDE_BY_ZERO_ERROR Option [TSQL]
  Controls the reporting of division by zero.
• DQP_ENABLED Option
  Temporary database option dqp_enabled allows you to enable or disable DQP at the connection level.
• EARLY_PREDICATE_EXECUTION Option
  Controls whether simple local predicates are executed before query optimization.
• ENABLE_LOB_VARIABLES Option
  Controls the data type conversion of large object variables.
• EXTENDED_JOIN_SYNTAX Option
  Controls whether queries with an ambiguous syntax for multi-table joins are allowed or are reported as an error.
• FORCE_DROP Option
  Causes Sybase IQ to leak, rather than reclaim, database disk space during a DROP command.
• FORCE_NO_SCROLL_CURSORS Option
  Forces all cursors to be non-scrolling.
• FORCE_UPDATABLE_CURSORS Option
  Controls whether cursors that have not been declared as updatable can be updated.
• FP_LOOKUP_SIZE Option
  Specifies the maximum number of lookup pages used in Sybase IQ and controls the amount of cache allocated to the creation of Lookup FP indexes, particularly FP(3) Indexes.
• FP_LOOKUP_SIZE_PPM Option
  Restricts FP lookup storage size in Sybase IQ to this parts-per-million value of main memory.
• FP_PREDICATE_WORKUNIT_PAGES Option
  Specifies degree of parallelism used in the default index.
• FPL_EXPRESSION_MEMORY_KB Option
  Controls the use of memory for the optimization of queries involving functional expressions against columns having enumerated storage.
• GARRAY_FILL_FACTOR_PERCENT Option
  Specifies the percent of space on each HG garray page to reserve for future incremental inserts into existing groups.
• GARRAY_INSERT_PREFETCH_SIZE Option
  Specifies number of pages used for prefetch.
• GARRAY_PAGE_SPLIT_PAD_PERCENT Option
  Determines per-page fill factor during page splits on the garray and specifies the percent of space on each HG garray page to reserve for future incremental inserts.
• GARRAY_RO_PREFETCH_SIZE Option
  Specifies number of pages used for prefetch.
• HASH_PINNABLE_CACHE_PERCENT Option
  Controls the maximum percentage of a user’s temp memory that a hash object can pin.
• HASH_THRASHING_PERCENT Option
  Specifies the percent of hard disk I/Os allowed during the execution of a statement that includes a query involving hash algorithms, before the statement is rolled back and an error message is reported.
• HG_DELETE_METHOD Option
  Specifies the algorithm used during a delete in a HG index.
• HG_SEARCH_RANGE Option
  Specifies the maximum number of Btree pages used in evaluating a range predicate in the HG index.
• HTTP_SESSION_TIMEOUT Option
  Specifies the amount of time, in minutes, that the client waits for an HTTP session to time out before giving up.
• IDENTITY_ENFORCE_UNIQUENESS Option
  Creates a unique HG index on each IDENTITY/AUTOINCREMENT column, if the column is not already a primary key.
• IDENTITY_INSERT Option
  Enables users to insert values into or to update an IDENTITY or AUTOINCREMENT column.
• INDEX_ADVISOR Option
  Generates messages suggesting additional column indexes that may improve performance of one or more queries.
• INDEX_ADVISOR_MAX_ROWS Option
  Sets the maximum number of unique advice messages stored by the index advisor to max_rows.
• INDEX_PREFERENCE Option
  Controls the choice of indexes to use for queries.
• INFER_SUBQUERY_PREDICATES Option
  Controls the optimizer’s inference of additional subquery predicates.
• IN_SUBQUERY_PREFERENCE Option
  Controls the choice of algorithms for processing an IN subquery.
• IQGOVERN_MAX_PRIORITY Option
  Limits the allowed IQGOVERN_PRIORITY setting.
• IQGOVERN_PRIORITY Option
  Assigns a priority to each query waiting in the -iqgovern queue.
• IQGOVERN_PRIORITY_TIME Option
  Limits the time a high priority query waits in the queue before starting.
• ISOLATION_LEVEL Option
  Controls the locking isolation level for catalog store tables.
• JAVA_LOCATION Option
  Specifies the path of the Java VM for the database.
• JAVA_VM_OPTIONS Option
  Specifies command line options that the database server uses when it launches the Java VM.
• JOIN_EXPANSION_FACTOR Option
  Controls how conservative the optimizer’s join result estimates are in unusually complex situations.
• JOIN_OPTIMIZATION Option
  Enables or disables the optimization of the join order.
• JOIN_PREFERENCE Option
  Controls the choice of algorithms when processing joins.
• JOIN_SIMPLIFICATION_THRESHOLD Option
  Controls the minimum number of tables being joined together before any join optimizer simplifications are applied.
• LARGE_DOUBLES_ACCUMULATOR Option
  Controls which accumulator to use for SUM or AVG of floating-point numbers.
• LF_BITMAP_CACHE_KB Option
  Specifies the amount of memory to use for a load into a LF index.
• LOAD_ZEROLENGTH_ASNULL Option
  Specifies LOAD statement behavior under certain conditions.
• LOCKED Option
  If set for a login policy, prevents users with that policy from establishing new connections.
• LOG_CONNECT Option
  Controls logging of user connections.
• LOG_CURSOR_OPERATIONS Option
  Controls logging of cursor operations.
• LOGIN_MODE Option
  Controls the use of integrated logins for the database.
• LOGIN_PROCEDURE Option
  Specifies a login procedure that sets connection compatibility options at start-up.
• MAIN_RESERVED_DBSPACE_MB Option
  Controls the amount of space Sybase IQ reserves in the IQ main store.
• MAX_CARTESIAN_RESULT Option
  Limits the number of rows resulting from a Cartesian join.
• MAX_CLIENT_NUMERIC_PRECISION Option
  Controls the maximum precision for numeric data sent to the client.
• MAX_CLIENT_NUMERIC_SCALE Option
  Controls the maximum scale for numeric data sent to the client.
• MAX_CONNECTIONS Option
  Specifies the maximum number of concurrent connections allowed for a user.
• MAX_CUBE_RESULT Option
  Sets the maximum number of rows that the IQ optimizer considers for a GROUP BY CUBE operation.
• MAX_CURSOR_COUNT Option
  Specifies a resource governor to limit the maximum number of cursors that a connection can use at once.
• MAX_DAYS_SINCE_LOGIN Option
  Specifies the maximum number of days that can elapse between two successive logins by the same user.
• MAX_FAILED_LOGIN_ATTEMPTS Option
  Specifies the maximum number of failed attempts, since the last successful attempt, to log into the user account before the account is locked.
• MAX_HASH_ROWS Option
  Sets the maximum number of rows that the IQ optimizer considers for a hash algorithm.
• MAX_IQ_THREADS_PER_CONNECTION Option
  Controls the number of threads for each connection.
• MAX_IQ_THREADS_PER_TEAM Option
  Controls the number of threads allocated to perform a single operation (such as a LIKE predicate on a column) executing within a connection.
• MAX_JOIN_ENUMERATION Option
  Controls the maximum number of tables to be optimized for join order after optimizer simplifications have been applied.
• MAX_PREFIX_PER_CONTAINS_PHRASE Option
  Specifies the number of prefix terms allowed in a text search expression.
• MAX_QUERY_PARALLELISM Option
  Sets upper bound for parallel execution of GROUP BY operations and for arms of a UNION.
• MAX_QUERY_TIME Option
  Sets a time limit so that the optimizer can disallow very long queries.
• MAX_STATEMENT_COUNT Option
  Specifies a resource governor to limit the maximum number of prepared statements that a connection can use at once.
• MAX_TEMP_SPACE_PER_CONNECTION Option
  Limits temporary store space used per connection.
• MAX_WARNINGS Option
  Controls the maximum number of warnings allowed.
• MINIMIZE_STORAGE Option
  Minimizes use of disk space for newly created columns.
• MIN_PASSWORD_LENGTH Option
  Sets the minimum length for new passwords in the database.
• MONITOR_OUTPUT_DIRECTORY Option
  Controls placement of output files for the IQ buffer cache monitor.
• MPX_AUTOEXCLUDE_TIMEOUT Option
  Specifies timeout for auto-excluding a secondary node on the coordinator node.
• MPX_HEARTBEAT_FREQUENCY Option
  Specifies interval until the heartbeat thread wakes and cleans up the connection pool on the secondary node.
• MPX_IDLE_CONNECTION_TIMEOUT Option
  Specifies the time after which an unused connection in the connection pool on a secondary node will be closed.
• MPX_MAX_CONNECTION_POOL_SIZE Option
  Specifies the maximum number of connections allowed in the connection pool on a secondary node.
• MPX_MAX_UNUSED_POOL_SIZE Option
  Specifies the maximum number of unused connections in the connection pool on a secondary node.
• MPX_WORK_UNIT_TIMEOUT Option
  Time, in seconds, before a multiplex DQP leader reassigns a distributed work unit to another DQP worker node.
• NEAREST_CENTURY option [TSQL]
  Controls the interpretation of 2-digit years, in string to date conversions.
• NOEXEC Option
  Generates the optimizer query plans instead of executing the plan.
• NON_ANSI_NULL_VARCHAR Option
  Controls whether zero-length VARCHAR data is treated as NULLs for insert, load, and update operations.
• NON_KEYWORDS Option [TSQL]
  Turns off individual keywords, allowing their use as identifiers.
• NOTIFY_MODULUS Option
  Controls the default frequency of notify messages issued by certain commands.
• ODBC_DISTINGUISH_CHAR_AND_VARCHAR Option
  Controls how the Sybase IQ and SQL Anywhere ODBC driver describes CHAR columns.
• ON_CHARSET_CONVERSION_FAILURE Option
  Controls the action taken, if an error is encountered during character conversion.
• ON_ERROR Option [Interactive SQL]
  Controls the action taken if an error is encountered while executing statements in Interactive SQL.
• ON_TSQL_ERROR Option [TSQL]
  Controls error handling in stored procedures.
• OS_FILE_CACHE_BUFFERING Option
  Controls use of file system buffering for IQ Main dbspaces.
• OS_FILE_CACHE_BUFFERING_TEMPDB Option
  Controls the use of file system buffering for IQ Temporary dbspaces.
• PASSWORD_EXPIRY_ON_NEXT_LOGIN Option
  Marks the user’s password for expiry immediately upon next login, when a user is assigned a login policy and this option for the policy is set ON.
• PASSWORD_GRACE_TIME Option
  Specifies the number of days before password expiration during which login is allowed, but the default post login procedure issues warnings.
• PASSWORD_LIFE_TIME Option
  Specifies the maximum number of days before a password must be changed.
• POST_LOGIN_PROCEDURE Option
  Specifies a login procedure whose result set contains messages that are displayed by the client application immediately after a user successfully logs in.
• PRECISION Option
  Specifies the maximum number of digits in the result of any decimal arithmetic, for queries on the catalog store only.
• PREFETCH Option
  Allows you to turn fetching on or off or to use the ALWAYS value to prefetch the cursor results, even for SENSITIVE cursor types and for cursors that involve a proxy table.
• PREFETCH_BUFFER_LIMIT Option
  Specifies the amount of memory used for prefetching.
• PREFETCH_BUFFER_PERCENT Option
  Specifies the percent of memory used for prefetching.
• PREFETCH_GARRAY_PERCENT Option
  Specifies the percent of prefetch resources designated for inserts to HG indexes.
• PREFETCH_SORT_PERCENT Option
  Specifies the percent of prefetch resources designated for sorting objects.
• PRESERVE_SOURCE_FORMAT Option [database]
  Controls whether the original source definition of procedures, views, and event handlers is saved in system files. If saved, the formatted source is saved in the column source in SYSTABLE, SYSPROCEDURE, and SYSEVENT.
• QUERY_DETAIL Option
  Specifies whether or not to include additional query information in the Query Detail section of the query plan.
• QUERY_NAME Option
  Gives a name to an executed query in its query plan.
• QUERY_PLAN Option
  Specifies whether or not additional query plans are printed to the Sybase IQ message file.
• QUERY_PLAN_AFTER_RUN Option
  Prints the entire query plan after query execution is complete.
• QUERY_PLAN_AS_HTML Option
  Generates graphical query plans in HTML format for viewing in a Web browser.
• QUERY_PLAN_AS_HTML_DIRECTORY Option
  Specifies the directory into which Sybase IQ writes the HTML query plans.
• QUERY_PLAN_TEXT_ACCESS Option
  Enables or prevents users from accessing query plans from the Interactive SQL client or from using SQL functions to get plans.
• QUERY_PLAN_TEXT_CACHING Option
  Allows you to specify whether or not Sybase IQ generates and caches IQ plans for queries executed by the user.
• QUERY_ROWS_RETURNED_LIMIT Option
  Sets the row threshold for rejecting queries based on estimated size of result set.
• QUERY_TEMP_SPACE_LIMIT Option
  Specifies the maximum estimated amount of temp space before a query is rejected.
• QUERY_TIMING Option
  Determines whether or not to collect specific timing statistics and display them in the query plan.
• QUOTED_IDENTIFIER Option [TSQL]
  Controls the interpretation of strings that are enclosed in double quotes.
• RECOVERY_TIME Option
  Sets the maximum length of time, in minutes, that the database server takes to recover from system failure.
• RESERVED_KEYWORDS Option
  Turns on individual keywords that are disabled by default.
• RETURN_DATE_TIME_AS_STRING Option
  Controls how a date, time, or timestamp value is passed to the client application when queried.
• ROUND_TO_EVEN Option
  Controls behavior of the SQL function ROUND.
• ROW_COUNT Option
  Limits the number of rows returned from a query.
• SCALE Option
  Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION, for queries on the catalog store only.
• SIGNIFICANTDIGITSFORDOUBLEEQUALITY Option
  Specifies the number of significant digits to the right of the decimal in exponential notation that are used in equality tests between two complex arithmetic expressions.
• SORT_COLLATION Option
  Allows implicit use of the SORTKEY function on ORDER BY expressions.
• SORT_PINNABLE_CACHE_PERCENT Option
  Specifies the maximum percentage of currently available buffers a sort object tries to pin.
• SQL_FLAGGER_ERROR_LEVEL Option [TSQL]
  Controls the behavior in response to any SQL code that is not part of the specified standard.
• SQL_FLAGGER_WARNING_LEVEL Option [TSQL]
  Controls the response to any SQL that is not part of the specified standard.
• STRING_RTRUNCATION Option [TSQL]
  Determines whether an error is raised when an INSERT or UPDATE truncates a CHAR or VARCHAR string.
• SUBQUERY_CACHING_PREFERENCE Option
  Controls which algorithm to use for processing correlated subquery predicates.
• SUBQUERY_FLATTENING_PERCENT Option
  Allows the user to change the threshold at which the optimizer decides to transform scalar subqueries into joins.
• SUBQUERY_FLATTENING_PREFERENCE Option
  Allows a user to override the decisions of the optimizer when transforming (flattening) scalar or EXISTS subqueries into joins.
• SUBQUERY_PLACEMENT_PREFERENCE Option
  Controls the placement of correlated subquery predicate operators within a query plan.
• SUPPRESS_TDS_DEBUGGING Option
  Determines whether TDS debugging information appears in the server window.
• SWEEPER_THREADS_PERCENT option
  Specifies the percentage of Sybase IQ threads used to sweep out buffer caches.
• TDS_EMPTY_STRING_IS_NULL Option [database]
  Controls whether empty strings are returned as NULL or a string containing one blank character for TDS connections.
• TEMP_EXTRACT_APPEND Option
  Specifies that any rows extracted by the data extraction facility are added to the end of an output file.
• TEMP_EXTRACT_BINARY Option
  In combination with the TEMP_EXTRACT_SWAP option, specifies the type of extraction performed by the data extraction facility.
• TEMP_EXTRACT_COLUMN_DELIMITER Option
  Specifies the delimiter between columns in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_DIRECTORY Option
  Controls whether a user is allowed to use the data extraction facility. Also controls the directory into which temp extract files are placed and overrides a directory path specified in the TEMP_EXTRACT_NAMEn options.
• TEMP_EXTRACT_ESCAPE_QUOTES Option
  Specifies whether all quotes in fields containing quotes are escaped in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_NAMEn Options
  Specifies the names of the output files or named pipes used by the data extraction facility. There are eight options: TEMP_EXTRACT_NAME1 through TEMP_EXTRACT_NAME8.
• TEMP_EXTRACT_NULL_AS_EMPTY Option
  Controls the representation of null values in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_NULL_AS_ZERO Option
  Controls the representation of null values in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_QUOTE Option
  Specifies the string to be used as the quote to enclose fields in the output of the data extraction facility for an ASCII extraction, when either the TEMP_EXTRACT_QUOTES option or the TEMP_EXTRACT_QUOTES_ALL option is set ON.
• TEMP_EXTRACT_QUOTES Option
  Specifies that string fields are enclosed in quotes in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_QUOTES_ALL Option
  Specifies that all fields are enclosed in quotes in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_ROW_DELIMITER Option
  Specifies the delimiter between rows in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_SIZEn Options
  Specifies the maximum sizes of the corresponding output files used by the data extraction facility.
• TEMP_EXTRACT_SWAP Option
  In combination with the TEMP_EXTRACT_BINARY option, specifies the type of extraction performed by the data extraction facility.
• TEMP_RESERVED_DBSPACE_MB Option
  Controls the amount of space Sybase IQ reserves in the temporary IQ store.
• TEMP_SPACE_LIMIT_CHECK Option
  Checks for catalog store temporary space on a per connection basis.
• TEXT_DELETE_METHOD Option
  Specifies the algorithm used during a delete in a TEXT index.
• TIME_FORMAT Option
  Sets the format used for times retrieved from the database.
• TIMESTAMP_FORMAT Option
  Sets the format used for timestamps retrieved from the database.
• TOP_NSORT_CUTOFF_PAGES Option
  Sets the result size threshold for TOP N algorithm selection.
• TRIM_PARTIAL_MBC Option
  Allows automatic trimming of partial multibyte character data.
• TSQL_VARIABLES Option [TSQL]
  Controls whether the @ sign can be used as a prefix for Embedded SQL host variable names.
• USER_RESOURCE_RESERVATION Option
  Adjusts memory use for the number of current users.
• VERIFY_PASSWORD_FUNCTION Option
  Specifies a user-supplied authentication function that can be used to implement password rules.
• WASH_AREA_BUFFERS_PERCENT Option
  Specifies the percentage of the buffer caches above the wash marker.
• WAIT_FOR_COMMIT Option
  Determines when foreign key integrity is checked as data is manipulated.
• WD_DELETE_METHOD Option
  Specifies the algorithm used during a delete in a WD index.