0

Is there any difference between the below two styles of using temporary tables in Redshift -- in terms of cluster performance (or) R/W into and from the table?

I am new to Redshift, hence bit unaware of the column compression (encodings) and how it affects query/cluster performance.

On Redshift version -

PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.52931

Please advise, and help to learn. Much appreciated. :)

-- Query 1 -- 
SELECT...INTO #tmp_t WHERE...;

or

-- Query 2 -- 
CREATE TEMPORARY tmp_t (
     . . . 
     . . .
);
INSERT INTO tmp_t SELECT ...;

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.