Posted by Doug on 03/13/06 21:35

if you are going ot have a materialized view, why not just bite the
bullet and have a denormalized table hanging around that gets updated
all the time.

the optimizer is fine for 90 percent of the time.

• Next in forum: Re: Getting list of recently added IDENTITY items
• Prev in forum: Re: Naming syntax in 2005
• Thread view: Re: Different query plans for view and view definition statement

[Reply to this message]