Re: how to optimise query for 10+ millions records

[irek kordirko]

Azhar Rahi Wrote:
-------------------------------------------------------
> @irek .. These two tables are temporary tables,
> which are created when someone pass comma
> separated value to the stored procedure. This
> comma separated string is then converted to
> temporary tables. So I cant turn its field 'value'
> constraint to P.K.

Why you can't ?
Just modify your procedure:

CREATE TEMPORARY TABLE xxx(
  value varchar(100) PRIMARY KEY
);

If you don't want to use PK, then create an index on this field.
And remember to alter your temp tables specyfikations and make value column NOT NULL,