hi
thanx for that. Since anil was asking whether he should update statistics from sql server, thats why I thought may be it can be done from somewhere else.
have u checked whether inedx hint is forcing the optimizer to do query in a certain way? I would tend to agree with something like forceplaceholders etc but I thought index hint is redundant
regards
harry
Varden Morris <[EMAIL PROTECTED]> wrote:
Hi Harry,I am almost sure it cannot be done from Axapta up to V3.0 SP4. I do not know of any third party solution out there. Axapta depends on MSSQL most times to use its statistics in queries. However, there are some options that you may use from Axapta to force the MSSQL optimizer to do a query in a specific way. For example, "Index Hint".
"Harry (Harshawardhan Deshpande" <[EMAIL PROTECTED]> wrote:hi Varden, AnilJust curious, is there any other place where the statistics can be updated?regardsharry
Varden Morris <[EMAIL PROTECTED]> wrote:Hi Anil,There is no problem with this. That's where it should be done. You should setup a maintenance plan to do this on a weekly basis during off peak hours. The auto update feature of SQL may not update the statistics that frequently, that's why it is recommended to do it through a schedule maintenance plan.
ANIL OZAY <[EMAIL PROTECTED]> wrote:Hi all,
I want to ask a critical question about Axapta. Can i update statictics
from SQL Server? Is there a problem about this?
Anil Ozay
Software Engineer, Axapta Specialist
MBSCP,MCP
Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.
This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system.
Sharing the knowledge on Axapta.
Varden Morris
Senior Developer
WellPoint Systems Inc.
(403) 444-5848 direct
(403) 444-3900 main(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
Varden Morris
Senior Developer
WellPoint Systems Inc.
(403) 444-5848 direct
(403) 444-3900 main(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
