0 - 4 of 4 tags for INSERT INTO
TD 14 - Data Storage Questions
--create table 
CREATE SET TABLE database.table,
 NO FALLBACK ,
 NO BEFORE JOURNAL,
 NO AFTER JOURNAL,
 CHECKSUM = DEFAULT,
 DEFAULT MERGEBLOCKRATIO
 (
        some columns...,
 unique_number_10_digits CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL
 )
PRIMARY INDEX( unique_number_10_digits );

--inserts
By sallad, 10 Jul 2016 | Tagged: char varchar create table INSERT INTO | 4 comments
all-AMPs MERGE into from Spool N (Last Use) - Huge Estimation Difference

Apologies if  might have already been answered in this forum, but my 5 minute search did not get me anywhere. Hence a new thread.
Running SQLA 14.01 on TD14
Issue:

By nomadic_being, 19 Sep 2014 | Tagged: explain plan different explain teradata explain INSERT INTO join performance | 2 comments
copying table from Prod to QA

Hi everyone,
I'm struggling with a problem where I'm suppose to copy the data from table Technical_year in prod environment to Technical_year in QA environment.
They are actually views and the definition looks today like:
For QA environment:
REPLACE VIEW DWQ_QFU.MAN_TECH_YEAR
AS
SELECT *
FROM

By emilahlstrom, 10 Sep 2014 | Tagged: INSERT INTO copy data copy table teradata for beginners | 6 comments
INSERT INTO new table from existing query output

I am trying to put into a table the output from a previous query (saved as a volatile table).  I am creating a new table PROC_STATS to hold the output and then using INSERT INTO followed by a SELECT query to get the data inot PROC_STATS.  When I run the code in SQL Assistant, I get a message that 1 row was returned, which is the correct value.  However, w

By BBerszoner, 16 Apr 2013 | Tagged: INSERT INTO create table | 1 comment