Hi Donny, If your actual problem is why it is slow in Ax compared to direct sql in the database, I suggest you use sql server profiler to capture whether there is difference between your direct sql and the sql generated by Ax kernel.
Regards, Agus On Fri, Jul 9, 2010 at 7:55 AM, mgk915 <mae...@alrinach.net> wrote: > > > Yes, you do not want to change an existing index. > Can you tell me what table and field you have the sum on? > And tell me what fields you are using to group-by. > > - Maeve > > > > > > > > --- In > > Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>, > Donny Wu <Doni.Wu@> wrote: > > > > > > Hi, > > > > > > Yes I have 2 index, currently my cluster index is use another index but > if I > > > change the cluster into index that I use for select it will boost the > > > performance and in this case it will slow the other query that use the > other > > > index. > > > > > > dwu > > > > > > > >
