Re: Create table temp or select into temp.

CREAT TABLE and create ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 6 May 1996, Bryan Tonnet wrote: > Riddle me this Bat(wo)men... > > What are the differences between creating a temp table via CREATE TABLE, > and selecting INTO TEMP? > > Obviously, you get more flexibility in the CREATE TABLE alternative, but > the coding advantages of INTO TEMP are too juicy too ignore. Is there > trap here for the unwary? I scanned the manuals but found nothing on > performance (or anything else about the inner workings) betwen these options. > > Bryan. >