SQL语句优化:执行计划的脚本样例
rm -rf sqexplain.out
echo "测试本次SQL"
`dbaccess xxxxxdb <<! 2>> explain.log
set explain on;
select * from xxxxx where
playDay='2018-08-26' and valid = '1';
set explain off;
!`
echo "测试SQL结束"
tail -1200 explain.log
SQL语句优化:执行计划的脚本样例
rm -rf sqexplain.out
echo "测试本次SQL"
`dbaccess xxxxxdb <<! 2>> explain.log
set explain on;
select * from xxxxx where
playDay='2018-08-26' and valid = '1';
set explain off;
!`
echo "测试SQL结束"
tail -1200 explain.log