If you're using msSQL2000, I'd highly suggest looking into using table variables instead of views.
E > -----Original Message----- > From: Raster, Tim [mailto:[EMAIL PROTECTED] > > In SQL 7 and 2000, what is the feeling of using Views to represent data > joined by between 2-5 tables, and using that view in the place of > complicated inner join clauses in a query? On the one hand, code is > much cleaner because you join against a single View instead of many > joined tables. On the other hand, I've read that query engines may join > all the data in those tables together before it does anything, which > makes it slow due to joining data it doesn't need. My tables are large > in some cases. > > Thoughts? Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
