Re: performance

[Mikael Ronström]

Your table is partitioned on the column did.
So the query will scan all rows in the partition
to find the rows. The rows are not sorted in
any specific order with regards to the 'did' column.
So yes, this query will slow down with more rows in
the table since more rows have to be examined.

So a simple change that will speed up your query
substantially is to swap the order of the Primary Key
index from uniqueid,did to did,uniqueid. In this
case the ordered index of the primary key will
only check read rows with did=xyz.