> 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

Reply via email to