On Mon, Nov 8, 2010 at 12:15 PM, Matthieu Huin <matthieu(dot)huin(at)wallix(dot)com> wrote:
> Greetings all,
>
> I am trying to optimize SELECT queries on a large table (10M rows and more)
> by using temporary tables that are subsets of my main table, thus narrowing
> the search space to a more manageable size.
> Is it possible to transfer indices (or at least use the information from
> existing indices) from the big table to its subset in a reasonable amount of
> time ?
Are you sure that the benefit of creating scratch tables is worth the
overhead? Can you give explain/analyze of the query you are trying
to optimize?
merlin