Make insertion to the target table quicker

Database
Enthusiast

Make insertion to the target table quicker

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

Tags (1)
1 REPLY
Enthusiast

Re: Make insertion to the target table quicker

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.