I am trying to evaluate what are the best options for performing some calculations and data queries using Firebird tables.

At present I can see two options:
- use usual tables with dedicated field for storing some session id
- use global temporary tables

The question is - do global temporary tables have performance advantages over usual tables? And whether global temporary tables were designed with optimization goal in mind at all? Maybe they have different goals?

Thanks,
Tomr