Hello,
Is there any document available in the net regarding "optimize the
query" and "Index".
If so please tell me.It will be really helpful for us.

Regards,

Sivaraman

--- In ib-support@yahoogroups.com, Daniel Rail <daniel@a...> wrote:
> 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)