From: Anonymouse <ano...@we...> - 2001-03-15 14:34:52
|
I couldn't agree more... I think the concept of memory only may be nice, however I've seen temporary tables larger than you'd want in memory by any means... "temporary" is after all a relative term. >Oh, for a specification! "Temporary Table" does not >require that it be stored in memory; that's an >implementation detail. Without a copy of the spec, I think >that all temporary table requires is that [a] some sort of >indication on the CREATE command, and [b] an automatic >destruction at the proper time. Whatever we do should >follow the standard. am. |