OK. So the read should not be a major problem. I was just concerned you might have some queries from inefficient pipelined table functions or something like that.

If you have the system to yourself then you are laughing.

One thing to consider, if you are removing indexes from a number of tables you are going to affect you FK validations. You will need to way up the impact of this compared to write speed improvements. It may be that you could disable the FKs also, but be careful not to load rubbish data or you will spend the rest of your life fixing the FK issues.

Cheers

Tim...