At 02:29 PM 11/30/2004, Pavel Cisar wrote:

>There are two reasons for "magic" temporary tables, and both come down to
>performance:
>
>1. . Connection id would very likely have very bad cardinality, so filter
>performance would be bad even with index on it.
>
>2. Data cleanup. It would have the same problems of large deletes like in
>normal table. With separate table it's easy to scrap all data pages which
>is quick and cheap. BTW, there is a feature request pending for EMPTY or
>PURGE/DELETE ALL command that would quickly remove all data from table.

If we use Nickolay's suggestion for the physical implementation, it
will have exactly those characteristics. At the moment, I've fallen
out of love with my suggestion about using temporary tables because
of the potential for abuse.

Regards,


Ann