Just quick notes about the index for tmp sys table.

it's useless to create index just after tmp table creation. I add index after I fill table with data. Then the...