Re: Temp tables and LIKE

Posted in 1997

Carlos Antonio Ruiz Gomez — 10 Nov 1997 09:48:19 -0500 — source: Informix-list mailing list archive (1991-1998)

The syntax for create temp table like is the following: SELECT [columns that you want] FROM [tables that you want] WHERE table1.ROWID = 1.5 AND table2.ROWID = 1.5 AND ... INTO TEMP tmp_like I've found this syntax very fast because there is no 1.5 rowid, and the engine looks directly for data. The syntax WHERE 1=0 makes a sequential scan in all tables. ------------------------- Carlos Antonio Ruiz G'mez dmys2@colomsat.net.co Santaf' de Bogot' D. C. Colombia, Suram'rica