'Delete from table' query causes out of memory exception in my java program. Deleting large tables into smaller blocks may be a solution.
My question is, what should be the query to delete table in smaller blocks. I have tried both of the following queries, but none of them worked with hsqldb 1.8.
(1) delete from t where key IN (select key from t limit 100)
(2) delete from t where rownum() < 100
Looking forward for your suggestions.
The first one should work with some old versions. The second one is better and works in the new version.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.