Indexes in temporary tables

2001-12-29 Thread Goran Krajacic
I wonder if mysql uses indexes in temporary tables(when making a join on temp tables etc.)? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Indexes in temporary tables

2001-12-29 Thread Sinisa Milivojevic
Goran Krajacic writes: I wonder if mysql uses indexes in temporary tables(when making a join on temp tables etc.)? MySQL treats temp tables same as normal ones, except when the thread ends ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic