Re: Querying a MS SQL View...

That violates all good DBA practices. With proper indexes and normalization
you can read data from a table with millions of rows just about as fast as
from a table with a few thousand rows. Now you will have to modify all your
programs to take into account two tables .. plus, with the view doing a
join, you are probably makeing the DB do *more* work, not less :-)



.