i would like to know how to get rid of this problem,
some tables in our database get populated and deleted many times
therefore after a while even when the table is empty a select * from
table takes about 10 seconds
however after dropping and recreating the table the result of select
* from ... is of course immediate.
that table as a heap structure.
It seems like , like in oracle we have the watermark problem
therefore in oracle i just do a truncate table
but here ingres the result of a modify to truncated is that you lose
so is this problem something to do with the "watermark" and how can i
in a script that will be run every 2 weeks or so.