View previous topic :: View next topic
|
Author |
Message |
krithikaj
New User
Joined: 10 Aug 2008 Posts: 45 Location: India
|
|
|
|
Hi,
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.
1. DATE
2. DEPTARTMENT
3. CLASS
4. ITEM
5. LOCATION
6. TYPE
7. AMOUNT
8. QUANTITY
9. TIMESTAMP
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.
Thanks,
KJ |
|
Back to top |
|
|
abhishekmdwivedi
New User
Joined: 22 Aug 2006 Posts: 95 Location: india
|
|
Back to top |
|
|
krithikaj
New User
Joined: 10 Aug 2008 Posts: 45 Location: India
|
|
|
|
But this does not solve my issue.
Thanks,
KJ |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Run an explain on your query and see which part of your SQL is taking the most time .... chk for proper index usages and proper where clauses .... |
|
Back to top |
|
|
|