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@...