I have a View that joins a bunch of tables. If I do a select statement on that View whose result contains only a few columns, is the query optimizer smart enough not to perform all the superfluous ...

Next time, if you want to get the same information including customer name, check number, payment date, and amount, you need to issue the same query again. One way to do this is to save the query in a ...