Home » SQL & PL/SQL » SQL & PL/SQL » set forceplan on
set forceplan on [message #564504] Fri, 24 August 2012 07:59 Go to next message
anniepeteroracle
Messages: 43
Registered: March 2012
Location: hyderabad
Member
hi,
in sybase
set forceplan on;
statement is there.
what in oracle and db2 ?

by
annie
Re: set forceplan on [message #564506 is a reply to message #564504] Fri, 24 August 2012 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what does "set forceplan on" do?

Regards
Michel
Re: set forceplan on [message #564511 is a reply to message #564506] Fri, 24 August 2012 09:26 Go to previous messageGo to next message
dariyoosh
Messages: 532
Registered: March 2009
Location: Iran / France
Senior Member
Michel Cadot wrote on Fri, 24 August 2012 15:15
And what does "set forceplan on" do?

Regards
Michel


I think it is used in Sybase for optimization of joins.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00743_1500/html/qp_abstrpln/X20178.htm
Re: set forceplan on [message #564515 is a reply to message #564511] Fri, 24 August 2012 09:51 Go to previous message
Solomon Yakobson
Messages: 2007
Registered: January 2010
Senior Member
If set forceplan on is indeed used to force Adaptive Server to access tables in the order they are listed, Oracle equivalent would be LEADING or ORDERED hint.

SY.
Previous Topic: To handle the exception and continue the process
Next Topic: building dynamic SQL insert statement
Goto Forum:
  


Current Time: Sat Aug 30 11:52:35 CDT 2014

Total time taken to generate the page: 0.11916 seconds