Thanks I have read up this web site as well as others and understand cluster indexes but I guess my concern is has std AX table objects been setup with good cluster indexes? I guess I can look at the main volume tables such as inventtrans etc but I was just wondering if anyone had any feedback on their experience in this area of AX (i.e. should I be trusting MS on what they have done...usually the answer to this is no) Thanks James
James Flavell CITP Singapore Pte Ltd Mobile: +65 97582281 Email: [EMAIL PROTECTED] _____ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Max Belugin Sent: Wednesday, January 16, 2008 9:03 PM To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Re: Clsiter indexes yes or no? Have you reade this http://msdn2. <http://msdn2.microsoft.com/en-us/library/aa623224.aspx> microsoft.com/en-us/library/aa623224.aspx On 1/14/08, gollywogman <brandon.boman@ <mailto:brandon.boman%40isoft-tech.co.za> isoft-tech.co.za> wrote: > Hi there > As far as I know, (I could be mistaken) > the best thing to do is to have a cluster index only if a table has > one index, otherwise a table shouldn't have a cluster index. > > --- In development- <mailto:development-axapta%40yahoogroups.com> [EMAIL PROTECTED], James Flavell > <[EMAIL PROTECTED]> wrote: > > > > Should be disable cluster indexes or not in Ax4.0? > > > > I know the pros and cons but my impression is for AX at least we > should turn > > them of until someone in MS takes a good look and think slong and > hard about > > which index is the best as a clsuter index. > > > > Anyone agree/disagree? > > > > Thanks > > James > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > Yahoo! Groups Links > > > > -- Max Belugin, http://belugin. <http://belugin.info> info , ICQ:9406811, MSN: [EMAIL PROTECTED] <mailto:belugin%40mail.ru> ru [Non-text portions of this message have been removed]