Re: [Axapta-Knowledge-Village] SQL Index Statistics

[Harry \(Harshawardhan Deshpande]

hi
 
yup, index without a hint will force MSSQL to utilise the index, this comes in useful in cases where optimiser selects the wrong indexe. I do not think index hint serves any purpose from v3s3 onwards
 
regards
 
harry
Varden Morris <[EMAIL PROTECTED]> wrote:

I haven't checked but it should only be a hint. The database may or may not use it. I think I read in some documentation that "index" without the "hint" will force MSSQL to use the index."Harry (Harshawardhan Deshpande" <[EMAIL PROTECTED]> wrote: 

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, Anil
 
Just curious, is there any other place where the statistics can be updated?
 
regards
 
harryVarden 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 staticticsfrom SQL Server? Is there a problem about this?Anil OzaySoftware Engineer, Axapta SpecialistMBSCP,MCPBu 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  cellwww.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  cellwww.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  cellwww.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.





    


  
  
    SPONSORED LINKS
  
          
                  
            
        Business finance course
      
                      
        Business to business finance
      
                      
        Small business finance
      
              
                        
            
        Business finance consultant
      
                      
        Business finance magazine
      
                      
        Business finance schools
      
              
                    
           
  







  
  
  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.