Can CCR report performance be improved?
That depends...
If the Oracle DB is running on a Shared database server, then no.
The best performance from CCR reports will be found when CapMan is the ONLY database on the server.
If CapMan DB is the only DB on the server then you can improve performance with:
1. Enabling Partitioned tables.
2. Converting certain Views into Tables.
3. Building certain Materialized views for specific reports.
Only option 1 above is a feature available in the product that you can implement without a CA Services contract.
David