RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

hi Jens what the legacy programmer told you is correct for old axapta versions.(Ax 2.5) regards harryJens Strandberg [EMAIL PROTECTED] wrote: Hmm,I have also been told by a legacy Axapta programmer, that the field order inthe select statements should follow the index order ...I would like to

Re: [Axapta-Knowledge-Village] DataStatus on inventtrans

hi When searching especially in inventtrans it is very important to let the sql optimiser choose the correct index depending upon the data distribution (statistics in the sql server). If the same querry is going to be executed again and again and the performance is really bad then variables

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] DataStatus on inventtrans Hmm, I have also been told by a legacy Axapta programmer, that the field order in the select statements should follow the index order ... I would like to know too, if this is not correct. Thanks in advance

Re: [Axapta-Knowledge-Village] DataStatus on inventtrans

hi 1. the order of where clause statement is not important 2. I would recommend not putting any index hint to begin with and check the sql trace to see which index is being selected. 3. If you are not happy with the performance then try things like #placeholder etc. Depends on how many times

Re: [Axapta-Knowledge-Village] DataStatus on inventtrans

i belive the fields in the index should be in proper order. In case (in table inventTrans) you are using the Index StatusItemIdx then you need to include in your select statement first statusReceipt, then StatusIssue, then ItemId and then DateStatus. If you dont want to use any of these in

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

the importance of getting those right. Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Girish Bhatkal Sent: 28 September 2005 18:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] DataStatus

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

BhatkalSent: 28 September 2005 16:47To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] DataStatus on inventtrans Hi James,during one of my previous implementation (2 yrs back)we had some performance issues and a Consultant fromMS had visited us. he asked me

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Malcolm Burtt Sendt: 28. september 2005 18:19 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] DataStatus on inventtrans ASFAIK it shouldn't make any difference which order the fields in a where clause are specified as the SQL

[Axapta-Knowledge-Village] DataStatus on inventtrans

Title: Message Hi can somebody tell me the field 'DateStatus' on inventtrans is set at what points? I am just trying to improve performance on inventtrans searchs and can see the index 'StatusItemIdx' is useful to me. Basically I want to find all the inventtrans cost for sales invoices