> Quick question for all the database gurus on the list, does
> anyone know if
> views perform better or worse than the equivalent query using
> joins in a stored procedure?
>
> Also does this differ between database vendors?
OK, I'm talking from SQL Server experience here
Stored Procedures are
I gather the whole purpose of views is twofold: performance, and security.
- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Sunday, April 07, 2002 3:44 AM
Subject: Performance of views
>
Quick question for all the database gurus on the list, does anyone know if
views perform better or worse than the equivalent query using joins in a
stored procedure?
Also does this differ between database vendors?
Thanks
Kola
__