Grant Fritchey (4/8/2012)
Similar in concept, but OPENQUERY is like a pass through query. It puts the work on to the remote server.
this really worked. I replaced the entire query and put in the form of OPENQUERY. The view which use to take 40 secs came down to 16 secs !!!...Thank you so much. Learned something new again 🙂