sybase iq 优化【查看执行计划】

1)sql

sql advantge 中设置

set showplan on
set noexec on
go

select .......

go

set showplan off
set noexec off

go

2) procedure 

set showplan on
go
exec sp_name
go
set showplan off
go

http://www.itpub.net/thread-200126-1-1.html

http://blog.chinaunix.net/uid-16765068-id-3070615.html