Hi Lynn,

thank you for your fast reply.

Looking at your code, you use async sql operations to update and re-read:

update ....

select ....

Without locking, what happens if several...

Please excuse my late response, but I've been off for a while with other projects.

I just want to give some followup to the discussed problem.

Not being able to find the...

I'm not sure if I understand correctly...

Executing the SQL in Management Studio produces the following trace info:

'Worktable'-table. Scan count 0, logical read operations 0, physical read operations 0, Read-Ahead-read operations...

Using the German version of MSSQL, I might run into translation problems...

The menu "show estimated execution plan" shows:

...

Thank you for your quick reply.

Yes, indexes are defined for all relevant fields as ID, NORM, etc.

The indexes are recalculated every night.

The NORM field is varchar2(200).

Both mentioned tables are...