use a view - no drawbacks

-----Original Message-----
From: Alexander Tabakov [mailto:saho@...]
Sent: Thursday, 10 April 2003 5:44 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] View vs Stored procedure


Hi guys,

I have a select statement with several joins in it, so I think about
putting it somehow in the database. Generally I have 2 ways of doing
this:

1. Stored procedure returning multiple rows;
2. A view capsulating the joins needed.

What I am not sure is which option is better regarding speed?
Generally speakind do views have some hidden drawbacks?

--
Best regards,
Alexander mailto:saho@...



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/