Search the web
Sign In
New User? Sign Up
firebird-support · Support for Users of Firebird Releases
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
joining to procedure   Message List  
Reply | Forward Message #103323 of 105459 |
Re: [firebird-support] joining to procedure

Nick Upson wrote:
> I think I recall that the advice used to be that joins to stored procs
> should be the last joins done, is this still the case in 2.1

If stored procedure parameter is some column of some of the joined
tables, then yes. It's because data from table needs to be fetched to
supply the parameter to SP.

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================




Tue Jul 14, 2009 3:13 pm

mbabuskov
Offline Offline
Send Email Send Email

Forward
Message #103323 of 105459 |
Expand Messages Author Sort by Date

I think I recall that the advice used to be that joins to stored procs should be the last joins done, is this still the case in 2.1 [Non-text portions of this...
Nick Upson
upsonn
Offline Send Email
Jul 14, 2009
10:02 am

... If stored procedure parameter is some column of some of the joined tables, then yes. It's because data from table needs to be fetched to supply the...
Milan Babuskov
mbabuskov
Offline Send Email
Jul 14, 2009
3:17 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help