Oracle global temporary tables - maximum number of records?

Question

Is there a limit on the number of records in the global temporary table before it affects performance, and does it affect performance? I am talking here about millions of records that can be inserted into a global temporary table.

Answer 1

There is no hard limit on the number of entries in the global temporary table. Ultimately, the data will be written to disk and therefore will be subject to read / write speeds when inserting / updating data or querying a table. You would expect that performance (such as changing data and accessing data) would be about the same level as a regular table — a little faster as it creates fewer repetitions.

You can add indexes to the global temporary table to make it easier to retrieve a subset of rows (this will obviously slow down the insertion and consume more temporary space, this is a trade-off)

Answer 2

, , . GTT , . , - , , Oracle . . Tom Kyte , GTT.