How to handle tables having volatile data
santiJan 28 2011 — edited Jan 28 2011Hi,
We have a table in which we load millions of data and after validation a huge amount of data is deleted. After that the select statements (performing FTS) becomes slow. If we shrink the space, the queries becomes faster. But shrinking space requires additional time. We can consider creating index on the table. But the indexes will slow down the inserts.
I wanted to know, how do we handle such tables containing data which has volitile nature.
The database version is 10.2.0.5 and platform Windows server 2008.
Regards,