IN versus Exists | Retrieve only the info that is needed


Other important SQL tuning hints

Add the `FOR READ ONLY' clause on selects that are retrieving data that will not be updated. Determine whether additional indexes can help performance.