Delete and insert into table and query real time
I have requriement of doing full refresh of data a lookup table which always needs to be queryiable real time by customer. Currently i am doing inserting data using staging table and then
delete from temp1;insert into temp1 select * from temp1_stage;commit; However when query is done while the delete /insert operation is going on the query response is slow. Is there any alternate mechanism to do the operation without user query getting slow response?