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@xxxxxxxxxx
ketemaj on iChat
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
