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,