Re: [SQL] View Vs. Table

2007-03-09 Thread Bruno Wolff III
On Tue, Mar 06, 2007 at 09:32:19 -0500, Radhika Sambamurti <[EMAIL PROTECTED]> wrote: > > From the application's perspective the View is much better as data is > being stored in one place, reducing errors and also storage. > But from the db point of view, is there a bigger performace hit when I

[SQL] View Vs. Table

2007-03-08 Thread Radhika Sambamurti
Hi, I have two tables which currently are being aggregated into a third table. I am proposing eliminating or drastically shortening the 3rd aggregation table, and instead just using a View. Which brings me to the question, which is better? Reading from a table or a view or is there a difference i