Igor Ostrovsky on April 14th, 2009

In database terminology, a view is a named query that typically aggregates data from multiple tables. When using views, it is important to remember that querying a view will evaluate the query that defines the view. Repeated evaluation of the view – say from within a nested query – may seriously impact or even kill […]

Continue reading about Precomputed view: A cool and useful SQL pattern