Re: (SQL) UPDATING a table from a join

> The problem is that the where clauses in both the outer 'update' statement
> and the inner 'select' statement aren't utilizing the primary keys for either
> table. You're therefore doing a full_table scan on both tables for every
> record.

You're right, my UPDATE does not use any index nor any primary key. In that
case, the trouble is that there is a single index on the table PIECE_LIST
and that it is composed of several fields; PIECE_NO is only one of them. As
I am not allowed to create new indexes (the tables are part of a commercial
product) I cannot change this situation.

Thanks very much for your help.

Best regards

Emmanuel Baechler
Lausanne
Switzerland Received on Fri Jun 12 1998 - 10:25:48 CEST