Will block compression ='yes' statement will cause the insert statement slower ?
While doing insertion i have
SET QUERYBAND blockcompression='yes;' FOR SESSION;
INSERT INTO TARGET_TABLE (a1,b1,c1) (SELECT A1,B1,C1 FROM SOURCE_TABLE A1 JOIN SOURCE_TABLE1 B1 ON (A1.COL1 =b.COL1))
Total Number of records inserted :300000 (only 3 lakhs)
Time taken: 25 minutes
From the document:
Block-level compression can result in some operations using considerably more CPU while operating on compressed tables (for example, queries, insert/updates, archive and restores, and the Reconfiguration and CheckTable utilities). Unless the system is very CPU rich, these operations will impact other workloads and could lengthen elapsed response times.
Now you can do SET QUERYBAND blockcompression='NO;' FOR SESSION; and please let us know.