Hi!
Do anyone know how long a normal executiontion time for full optimize is? And what you can do to speed it up?
We have an application with about 5 000 000 records in the Fact table. We have scheduled 8 imports every day which creates about 100 000 records for every import in the Fac2 table. And we have sheduled one full optimize every night and this optimize takes about 45 minutes, is this normal for this number of records in the tables.