SQL (Structured Query Language) Question:
Download Questions PDF

You are joining a local and a remote table, the network manager complains about the traffic involved, how can you reduce the network traffic?

Answer:

Push the processing of the remote data to the remote instance by using a view to pre-select the information for the join. This will result in only the data required for the join being sent across.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is a Cartesian product?What is the default ordering of an ORDER BY clause in a SELECT statement?