Oracle knowledge sorting: More than Oracle
Common heap table limitations:
Table update with log overhead table deletion with flaws table record too large slow retrieval index back table read overhead large ordered insertion difficult to orderly read DELETE produce the most undo, the most redo, because undo also requires redo to protect "harvest, not just Oracle" (HD scan bookmarks PDF) download: Global temporary table: 1. After the transaction-based global temporary table commit or session connection exits, the system automatically deletes the session-based global temporary table. After the session is exited, the system automatically deletes the global temporary table. 2. Data is independent of different sessions, different sessions access the global temporary table. Different results are displayed. During one call and execution of the program, the global temporary table needs to clear records multiple times before inserting records, consider using a partition table that is invincible
-- Delete a partition table