This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / DB2 on UNIX: How to improve the performance of MERGE
-streetoflondon(streetoflondon);
2013-1-12
{601}
(#7994935@0)
-
If you have partitioned field in condition, it should avoid scan whole table.
-deep_blue(BLUE);
2013-1-14
(#7998133@0)
-
Thanks! The partition fields are in the condition, but the target table(huge table) is still scaned. I removed the ORDER BY from SELECT statement for source table, index access to target table is applied. Just don't know why.
-streetoflondon(streetoflondon);
2013-1-17
(#8005656@0)
-
Then you may need give more spare space to the database server.
-deep_blue(BLUE);
2013-1-18
(#8005876@0)
-
Good. It's great remind.
-streetoflondon(streetoflondon);
2013-1-21
(#8010709@0)