Mr. jacovangelder, Thank you for your reply.

And Sorry for incontinence about my description of VM in AWS. 

There is no doubt that r6g.4xlarge x 1~6 or r6g.8xlarge x 1~3 is insufficient in terms of computational processing and memory capacity.

When I looked into it, as you said, OPTIMIZE seems to place a large load on the CPU and memory by calculating column statistics for skipping.

I would like to somehow convince my boss to use r6g.4xlarge x 1~6 or r6g.8xlarge x 1~3.

Your answer was very helpful. thank you. May good things be with you for your kindness.