如果希望服务器选项设置在应用程序连接到联邦服务器时保持有效,可以使用这个语句。
Use this statement when you want a server option setting to remain in effect only while your application is connected to the federated server.
不管使用何种设置,OPTPROFILE绑定选项适用于所有静态语句。
The OPTPROFILE bind option applies to all static statements, regardless of any other Settings.
将 AUTOTRACE 选项设置为 ON 将允许显示该会话中执行的每条语句的说明和统计信息,以及查询结果,直至 AUTOTRACE 被禁用。
Setting the AUTOTRACE option ON will enable the display of explain and statistics information for each statement executed in that session along with query results, until the AUTOTRACE is disabled.
应用推荐