dbTalk Databases Forums  

Sybase ASE 15 optimizer level

sybase.public.ase.performance+tuning sybase.public.ase.performance+tuning


Discuss Sybase ASE 15 optimizer level in the sybase.public.ase.performance+tuning forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Romeo
 
Posts: n/a

Default Sybase ASE 15 optimizer level - 02-02-2012 , 08:20 AM






Doesn't anymore has experience on tuning the "optimizer level"?

It seems like a new feature since ASE 15.0.3 ESD#2, performance
related optimizer changes are not enabled by default.

As a result, as an DBA, we may need to change the value of parameter
"optimizer level" from the default value "ase_default" to
"ase_current" (enable all optimizer changes up through the current
ESD)

In my company's sybase estate, some application's performance issue
disappeared after changing the default "optimizer level".

Does anymore has the similar experience ?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.