Wei Yu wrote:

> Hi, Alex
>
> Thanks much!. The "inner join CONTACTS a on a.ID = c.CONTACT_ID + 0" does the trick. Here is my questions:
>
> 1)How to update indices statistics, I'm using DBW, IBExpert.
>
> 2)Is there any Docs/Articles/tips regarding how to optimize SQLs out there?
>
> Best Regards,
>
> William
>

William,

Take a look on IBPlanAlyzer, the help file is one of the best docs I
read about optimization.

Look on the archives for mesages from Arno Brinkman, Set (Svein Earling
Tysvaer) and Ann Harrison.

To update the index statistics use the SET STATISTICS command, you could
build a stored procedure to update all indices statistcs at once using
EXECUTE STATEMENT, look on the archives it appears more than one time,
if you could not find it, I will repost the procedure code.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br