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 Question | Next Question |
What is a Cartesian product? | What is the default ordering of an ORDER BY clause in a SELECT statement? |