RE: Temporary tables

>> Does Mckoi support temporary tables?
If you mean an in memory table then, no. All tables
have a data file associated with them and are
persistent.

However, creating a view in the FROM clause might
serve your purposes.  Via an embedded view it is
possible to force a particular order of processing in
a query.  The form looks something like this:

select t1.col1
     , vw.col1
  from table1 t1
     , ( select col1
              , col_fk 
           from table2 
              , table3
          where table2.col_fk = table3.col_fk ) vw
 where t1.col_pk = vw.col_fk;

The select in your previous post might benefit from
such a strategy.  The use of a subquery using IN is
rather slow.  Joining to a view--in FROM clause--can
be faster.

Regards, Jim



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]