hello,

> Any particular database (IB/Fb)? Which version ?

FB 1.0

> Windows/Linux/whatever (and version) ?

windows 2000 server

> View/table definitions ? (At least, the interesting parts)

Views

> Any other indexes ?

Only primary key index in all the master tables.

CUST - CUST_ID
SOURCE - SOURCE_ID
CTYP - CTYP_ID

> How many records are involved ?

27019

Regards,
Shiva
--- In ib-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
wrote:

> On Sun, 8 Jun 2003 10:24:21 +0000 (UTC), sivram_mail wrote:
>
> > This is my query.
> > ...
> > how to improve the performance of this query???
>
>
> Any particular database (IB/Fb)? Which version ?
> Windows/Linux/whatever (and version) ?
> View/table definitions ? (At least, the interesting parts)
> Any other indexes ?
> How many records are involved ?
> What is the PLAN?
> Any other pertinent info ...
>
>
> --
> Aage J.