Help with plan changing inner to left join problem ..

Article View: borland.public.interbase.sql

Article #274

Back to borland.public.interbase.sql Previous Next

#274

From: Karol Bieniaszewski
Date: Fri, 15 Feb 2008 11:04

30 lines
1659 bytes

Hi

i have this plan

SELECT
H.*, A.DT
FROM
HIST_DB H
INNER JOIN ADRESY_DB A ON H.ID_OBJ=A.ID
PLAN JOIN (H ORDER IXA_HIST_DB__DATAP__CZASP, A INDEX (PK_ADRESY_DB__ID))
ROWS 1000
ORDER BY H.DATAP ASC, H.CZASP ASC


and if i change inner join to Left Join this plan can not by used why?
how can i optimize this query plan for Left Join

SELECT
H.*, A.DT
FROM
HIST_DB H
LEFT JOIN ADRESY_DB A ON H.ID_OBJ=A.ID
PLAN JOIN (H ORDER IXA_HIST_DB__DATAP__CZASP, A INDEX (PK_ADRESY_DB__ID)) /* 
error IXA_HIST_DB__DATAP__CZASP can not be used i specified plan */
ROWS 1000
ORDER BY H.DATAP ASC, H.CZASP ASC


please help
Karol Bieniaszewski

Technical Details

Message-ID: <47b57053@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!multikabel.net!feed20.multikabel.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,a3f940ef4e9aa5f9,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl>
Newsgroups: borland.public.interbase.sql
Subject: Help with plan changing inner to left join problem ..
Date: Fri, 15 Feb 2008 12:04:53 +0100
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 195.205.151.58
Message-ID: <47b57053@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1203073107 195.205.151.58 (15 Feb 2008 02:58:27 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!multikabel.net!feed20.multikabel.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail