立即与支持人员聊天
与支持团队交流

SQL Optimizer for SAP ASE 3.8 - Release Notes

Show Default Plan

When the original SQL statement has parameters, you need to determine the data type of the parameters when executing the Show Plan, Optimize, Run Result, Run for all Records, or Run for First Record functions.

If you would like to view the query plan without needing to enter all the data types and values for the parameters, use the SQL | Show Default Plan to retrieve the query plan. In this case, all the parameters are assumed to have a BINARY data type when executing the Show Plan function. This is useful when you want to quickly investigate the query plan of the original SQL statement.

 

Related Topic

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级