dbTalk Databases Forums  

Optimization_goal = 'Response-time'

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Optimization_goal = 'Response-time' in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Breck Carter [Team iAnywhere]
 
Posts: n/a

Default Optimization_goal = 'Response-time' - 04-12-2006 , 01:57 PM






Is SET OPTION PUBLIC.Optimization_goal = 'Response-time' treated the
same way as 'first-row', in a version 9.0.2.3267 database?

Note that it is *very easy* to get this old value... all you have to
do is rebuild an old database and not check the options you get.

Breck


--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com

Reply With Quote
  #2  
Old   
anil k goel
 
Posts: n/a

Default Re: Optimization_goal = 'Response-time' - 04-12-2006 , 02:27 PM






Yes; 'Response-time' and 'First-row' are synonymous.

So are 'Resource-consumption' and 'All-rows'.

-anil

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter (AT) risingroad (DOT) com> wrote in
message news:t2fq32tq8ikt1t65qnn70neir0ka1kgufm (AT) 4ax (DOT) com...
Quote:
Is SET OPTION PUBLIC.Optimization_goal = 'Response-time' treated the
same way as 'first-row', in a version 9.0.2.3267 database?

Note that it is *very easy* to get this old value... all you have to
do is rebuild an old database and not check the options you get.

Breck


--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book:
http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com



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.