In my database views built on other views seem to process much more slowly than views based on tables. Is there anyway to speed up the processing of view based views or is it better to use table based views? View based views have the benefit as new rows are inserted into table then they are automatically inserted into the selection where as wouldn't table based views need to have the table dropped and reprojected each time new data is added or a different selection is desired? These are views based on group by statements with counts so there may be two or more views nested\paired together before arriving at the view definition that I'm wanting to use. Is there a better way to do this? _________________________________________________________________ Spell a grand slam in this game where word skill meets World Series. Get in the game. http://club.live.com/word_slugger.aspx?icid=word_slugger_wlhm_admod_april08
