I have a table that has to hold 18 months data in it. There are 9 columns and Max Rec length=41. The columns of the table are given below.
The table is partitioned on Column 1 till 5 as such there are 545 partitions. The table is loaded with utmost 20million rows using IBM LOAD Utility everyday.
Now, there is a SQL to be run that uses 3 tables other than this table that include conditions on columns 1 till 6. The SQl is ending with -905 error.
Could someone please advise me on what can be done to solve this issue.