Hi,

At June 8, 2003, 08:01, sivram_mail wrote:

> Only primary key index in all the master tables.

> CUST - CUST_ID
> SOURCE - SOURCE_ID
> CTYP - CTYP_ID

Create the following indices:

CUST - SOURCE_ID
CUST - CTYP_ID

And, now execute your query again. You should see a difference.

Having the proper indices really helps in optimizing a query for
performance.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)