* Global temporary tables can be explicitly dropped. When this occurs, the associated indexes and views are also dropped.

While global temporary tables have many standard data segment characteristics, what makes them unique is they also inherently possess many temporary segment characteristics, such as the following:

* One session can create a global temporary allowing other sessions to share its definition, yet not its data. For example, the mg user can create a global temporary table, insert rows, select rows, and commit. User oe can describe the table but will not see any rows before the commit (normal read-consistent behavior) or after the commit. The oe user can insert rows into the table, but will see only the rows they inserted. And if user mg disconnects, that user's data is removed, but user's oe data remains.