Skip to Content
Former Member
Feb 02, 2012 at 07:00 AM

Performance problem on MaxDB.



In Oracle 10.2g before database migration to MaxDB 7.8 data loading to Z-Table (Customized tables) use to take 15min. But in MaxDB 7.8 it is taking now 3 hrs. We never created secondary indexes on Oracle for Z-Table. But after creating the secondary index on MaxDB data loading is taking 7 min. Does it mean that MaxDB is not able to manage partial Key?

And also we were not able to find any difference on the Oracle system as far as table/view definition, so our conclusion is Oracle algorithm/calculation to access data work differently than MaxDB.

Please let us know if there are any parameters for to manage the partial key? And also without creating the secondary indexes on Z-Tables it is possible to get the same performance as with Oracle?