Quote:
|
Originally Posted by r937
which of them performs better? that depends on your database management system
|
Not only on the RDBMS, but also on the current status of the two tables (i.e., number of rows, width of the rows) and surroundings (presence of indexes, physical ordering of the data, ...)
Even with the same tables on the same RDBMS, but at different time instances, a different one from the three formulations will be the most performant one.