Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The benefit of this approach compared to having a specialized temp db (as in SQL Server, ORACLE, Postges) is that it makes experiments way easier. For exploratory purposes a user can use a temporary table. Once the results are verified. The user can drop the temporary table and rerun the exact same query on top of the permanent table.

...