Jeff, the document you suggested was not of much help.
Test was done with only one user on the system. CPU usage is below 10%. Window opens fast after restarting database, meaning there is nothing wrong with I/O or full table scans or disc sorting. It is not optimizer problem or row migration problem either than it would run slow after restarting the database. It is only that it slows down after it is accessed many times (it does update, not the insert).


Katarina