On Thu, 2006-10-05 at 12:52 -0400, Luke Lonergan wrote: > Create table as select ... Order by ... > > Copy to ...
Or in 8.2, "COPY TO (SELECT ... ORDER BY)" (My, that's a neat feature.) -Neil ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings