Good morning friends, I can gladly make an inquiry
I need to extract information from a table that has millions of records so I am using an insert - select but it is very slow, I am trying to implement bulk collect and could you tell me what you think about this extraction?
--orogonal
INSERT INTO TTRB_TF_MOV_CTA_CMP
(mov_cmp.cor_mov)
SELECT mov.cor_mov
FROM house;
--improvements
SELECT A.num_fac
BULK COLLECT INTO TTRB_TF_MOV_CTA_CMP
FROM house
Could you give me some idea of a faster way to extract the information and load it into another table with greater speed?