Kbase P162607: What is the fastest way to delete a table and its data by using SQL92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/03/2010 |
|
Status: Unverified
GOAL:
What is the fastest way to delete a table and its data by using SQL92?
GOAL:
Which is faster, dropping a table from the data dictionary or dropping a table using SQL92?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
Beginning in 10.0A functionality was added to SQL92 to make better use of Type II storage areas for some operations. This functionality does not currently have an ABL / 4GL equivalent.
Code was introduced to allow fast table deletions to be performed through SQL92 under certain conditions.
1) If a table is in a Type II area.
2) If a SQL92 statement is made to drop a table in a Type II area and the statement is committed.
The duration of the above steps is very short.
If the above steps are all contained in one set of SQL statements with multiple commits within the set the completion is almost instantaneous.
In a Type II area, space for a deleted object is available for immediate re-use after the transaction has committed.
In rare circumstances, creating a new object after deleting an object may add up to one cluster of additional space to the area before re-using the space of the existing object. This occurs when the same table number is internally re-used and the deleted object only contained one cluster.