Re: [SQL] [Fwd: View Vs. Table]

2007-03-06 Thread Andrew Sullivan
On Tue, Mar 06, 2007 at 09:40:52AM -0500, Radhika Sambamurti wrote: > But from the db point of view, is there a bigger performace hit when I > query a view Vs a table or is there no difference. It rather depends on your view definition. See the discussion of views and, especially, the discussion

[SQL] [Fwd: View Vs. Table]

2007-03-06 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