Subject | DEAD LOCK ON SQL |
---|---|
Author | Burak OZLER |
Post date | 2002-06-11T15:37:38Z |
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??
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??