Hey guys. I have a query that I would like to stick into a view for the ease of calling it in reporting services and such, however for some reason when I create a view with the select, and try to run the view, it takes 2 seconds to return it. If I run the select as is without making it into a view, it returns results instantly. What I am missing here, can someone please help? Here is another variable to throw in the mix. This view will access two remote servers to get the data for the select.