query-plan is that

PLAN SORT (JOIN (JOIN (JOIN (STOCK INDEX (X_STOCK_NAME),
STOCKGROUP INDEX (RDB$PRIMARY22)),
TABLE1 INDEX (RDB$PRIMARY37)),
TABLE2 INDEX (RDB$PRIMARY24)))

ibrahim Bulut
Software/Database Developer
Republic Of Turkey

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, July 02, 2003 6:23 PM
Subject: Re: [firebird-support] Sometimes Connection Lost


> Can you show the query-plan?
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com
>
>
> > Hi,
> > I am using Delphi 5, IBX and Interbase 6.2
> > I have select query.
> >
> > SELECT STOCK.ID, STOCK.NAME, STOK.BARCODE,
> > STOCKGROUP.CODE, STOCKGROUP.NAME,
> > TABLE1.CODE, TABLE1.NAME, TABLE2.CODE, TABLE2.NAME, TABLE2.DESCRIPTION
> > FROM STOCK STOCK
> > LEFT JOIN STOCKGROUP STOCKGROUP ON (STOCK.STOCKGROUP = STOCKGROUP.ID)
> > LEFT JOIN TABLE1 TABLE1 ON (STOCK.CODE1 = TABLE1.ID)
> > LEFT JOIN TABLE2 TABLE2 ON (STOCK.CODE2 = TABLE2.ID)
> > WHERE ((STOCK.STOCKGROUP = :STOKGROUPID)
> > ORDER BY STOCK.NAME
> >
> >
> > TABLE2.DESCRIPTION field type is Varchar(2000)
> >
> > when i run the query, sometimes server is crashing
> > but it becomes sometimes, not always.
> > and server log is that
> > C:\Program Files\Borland\InterBase\bin\ibserver.exe: terminated
abnormally
> > (-1073741819)
> >
> > what is the problem.
> > what i must do
> > thanks,
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>