The DROP statement interface

The following figure shows the processing for each fragment of a DROP TABLE or DROP DATABASE statement.
Figure 1. Processing a DROP statement
The flowchart shows am_open pointing to am_drop.
If you drop an inherited table whose index uses the virtual index interface, the following additional call sequence is invoked.
Figure 2. Processing a DROP statement on a table with a VII index
The flowchart shows am_open pointing to am_delete, which is pointing to am_close.

To avoid this additional call sequence when dropping an inherited table, drop the index before dropping the table.


Copyright© 2019 HCL Technologies Limited