Direct on the server in SQL Developer its only about 30 seconds quicker. SQL server with the query above takes 3-4 minutes. This query is running inside ADO connection VBA Excel ,the response is about the same amount of time. I'm not sure if I said that all right. I don't understand the last part of your question in regards to the 4 part naming. Are you referring to the aliases just?