Hyperstage supports the DELETE statement. For more information, see the PostgreSQL 9.2 Documentation.
DELETE FROM tbl_name [WHERE where_condition] [ORDER BY ...] [LIMIT row_count]
AUTOCOMMIT is also important for good DELETE performance. DELETE is designed to remove the older data from a table and free up disk space. It should be used sparingly to randomly delete data over a large fact table as this may cause a performance impact over time.
Occasionally, data is incorrectly loaded to a fact table. DELETE can be used effectively in this case to remove the fresh incorrect data and replace it with the corrected data.
WebFOCUS |