Subject DEAD LOCK ON SQL
Author Burak OZLER
This is my SQL string


SELECT URUN_KUTUK_ID
, CARIID
, MARKAID
, URUN_KOD
, URUN_AD_TR
, URUN_AD_EN
, GTIP
FROM URUN_KUTUK
WHERE URUN_KOD IN
(SELECT DISTINCT(GM_PART_NUMBER)
FROM INVOICE_DETAIL
WHERE INVOICE_MASTER_ID=437)

The table URUN_KUTUK have 3 index'es URUN_KUTUK_ID(PK), CARIID,
URUN_KOD(UNQ) and 888.666 Rows;

The SQL shows right PLANS, but execution goes forever...

I get the sub select result's from another platform and wright down them
to the IN clouse by hand with same records it took 3 second to get
results. But when using sub select sentence I get dead lock.

I'm using FB1 w2k with one CPU.

Goood Days

Any Advice??