Question 2: These two syntaxes are equivalent. SQL queries describe what you want. SQL processors (part of the DBMS) try to find the optimal way of answering your query. Only testing, within your own configuration, will tell you which is best.
PG
PG
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.