Hi,
On Wed, 2002-03-06 at 15:50, Scalper wrote:
> If I create a temporary heap table from a select statement, does the new
> table also inherit the indexes (indices?) from the original table. Or will
I think that every CREATE [...] TABLE [...] SELECT does not inherit any
indexes (doesn't mat
If I create a temporary heap table from a select statement, does the new
table also inherit the indexes (indices?) from the original table. Or will
I have to add an index to the temporary table after it is created?
For example, if I use:
CREATE TEMPORARY TABLE tempstudents TYPE=HEAP SELECT s