达梦设置系统子查询平坦化参数

发布时间 2023-11-15 23:27:27作者: 刚好遇见Mysql

SQL> select para_name,para_value from v$dm_ini where para_name='ENABLE_RQ_TO_NONREF_SPL';

LINEID PARA_NAME PARA_VALUE
---------- ----------------------- ----------
1 ENABLE_RQ_TO_NONREF_SPL 0

 

SQL> alter system set 'ENABLE_RQ_TO_NONREF_SPL'=1;
DMSQL executed successfully
used time: 24.019(ms). Execute id is 504.
SQL> select para_name,para_value from v$dm_ini where para_name='ENABLE_RQ_TO_NONREF_SPL';

LINEID PARA_NAME PARA_VALUE
---------- ----------------------- ----------
1 ENABLE_RQ_TO_NONREF_SPL 1

used time: 6.713(ms). Execute id is 505.