> From: Lucio Chiappetti <lu...@lambrate.inaf.it> > > On Tue, 7 Apr 2015, shawn l.green wrote: > >> The advantage to using temporary tables is that they can have indexes on >> them. You can create the indexes when you create the table or you can ALTER >> the table later to add them. > > if they are big, using proper indices is a must to get quick responses.
If your temp tables are read-mostly, create the table with the index. If you're doing a lot of writes, consider adding the index after the insertions. And the proper answer to any question of moderate or greater complexity is, "It depends..." :-) :::: I have never let my schooling interfere with my education. -- Mark Twain :::: Jan Steinman, EcoReality Co-op :::: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql