Hi,
I'm thinking about using a view for my application.
However, I'm wondering about how efficient it will be once I have a large amount of data
loaded.
Are views generated for every access ?
Are they generated when the underlying data changes ?
Whould it maybe be faster to have a seperate table alongside the base data, and
generate it via a trigger or stored procedure ?
Thanks
JohnT