Adaptive Server version 12.5.4 enabled options set inside login triggers to remain valid for the entire user session, and supported a list of exportable options. Adaptive Server 15.0.2 ESD #2 expands the list to include the following:
addend_union_all auto_query_tuning basic_optimization bushy_space_search distinct_hashing distinct_sorted distinct_sorting group_hashing group_inserting group_sorted hash_union_distinct index_intersection index_union hash_join merge_join merge_union_all |
merge_union_distinct multi_gt_store_index nary_nl_join nl_join opportunistic_distinct opportunistic_grouping optgoal opttimeout order_sorting parallel_query query_tuning_mem_limit query_tuning_time_limit replicated_partitioning showabstractplan showbestplan showcodegen |
showcounters showelimination showexecio showfinalplan showhistograms showliocosting showlogprops showlop showmanagers shownostats showparallel showpiocosting showpllcosting showsearchengine store_index streaming_sort |
For the list of options already supported, see the Adaptive Server Enterprise New Features Guide for version 12.5.4.
