Hi All,

If you were to insert 50,000+ rows into the following user temporary
table, (to be joined into later) which of the three methods would be
the quickest:

CREATE TABLE QRYTMP1
(
ID INTEGER NOT NULL ,
QTYPE CHAR DEFAULT 'C',
PRIMARY KEY (ID)
);

INSERT INTO qrytmp1 ...
1. SELECT id FROM x (qtype default fires)
2. SELECT id, 'C' FROM x (qtype explicit)
3. SELECT id, 'C' FROM x (lose default, qtype explicit)

Is (3) is the quickest?

Tom