Web lists-archives.com

Re: store search result as new table in memory

On Tue, 7 Apr 2015, shawn l.green wrote:

Temporary tables are going to become your very good friends.

yes I do use temporary tables a lot

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.

Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy)
For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html
Do not like Firefox >=29 ?  Get Pale Moon !  http://www.palemoon.org

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql