|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
MIN/MAX usageI have a temp table that I create to build some statistics, the results of which I copy back to a live table.
My question is in regards to MIN/MAX and other such functions... Do these get re-evaluated for every row, or is SQL smart enough to store the value for the next iteration? Because if they are re-evaluated every time, then I will definitely want to copy them into a variable first so they are only evaluated one time.  |
|||||||||||||||||||||||
Other interesting topics