Content Store and Navigation

[ghostraider]

Hi, Our environment is Cognos 8.2 on Solaris. Currently our content store is on Oracle 9 and we are going to upgrade it to Oracle 10g next week. Couple of my users have complained that navigation in Cognos Connection is not as fast as they would like it to be. For example trying to navigate through packages or folders, but i don't think it is so slow. It takes anywhere between 1sec-6 secs to move from one folder to another. Very rarely, yes we do have problems where it takes longer than 10secs. Is there anything i can do in the content store to fix this since we are upgrading it anyways? Could anyone let me know what common issues affect navigation in Cognos Connection and how it can be resolved. We do have a lot of unwanted reports in our content store and i think we should definitely clean them up. Can the indexes in the content store be rebuilt? If yes how? Please let me know. Thanks!!