if i have a "column" that is a calculation, say a bank balance -> sum
of all the debits and credits...is it more efficient to make a view
that executes the underlying calc query doing the math, or to create a
table that has a column called balance that is updated for each
transaction?
so in the end "select balance from view" or "select balance from
table" ?
What are the pros cons ?
Thanks
Ketema J. Harris
www.ketema.net
ketema@ketema.net
ketemaj on iChat
