Hi, Alex

Could you please repost the procedure code?

Thanks

William

Alexandre Benson Smith <iblist@...> wrote: 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



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




SPONSORED LINKS
Technical support Computer technical support Compaq computer technical support Compaq technical support Hewlett packard technical support Microsoft technical support

---------------------------------
YAHOO! GROUPS LINKS


Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





William, Yu


---------------------------------
Relax. Yahoo! Mail virus scanning helps detect nasty viruses!

[Non-text portions of this message have been removed]