RE: Spam:Re: [Axapta-Knowledge-Village] Clusteredindex on inventsum inventdim

Hi Harry, thanks for your response, How does having serial number active change anything? I still dont feel to confident setting that index, maybe there is something else wrong with this query? select count(recid) from InventSum where InventSum.itemId == WMSOrderTrans.itemId

RE: Spam:Re: [Axapta-Knowledge-Village] Clusteredindex on inventsum inventdim

Hi Harry, thanks for your response, How does having serial number active change anything? I still dont feel to confident setting that index, maybe there is something else wrong with this query? select count(recid) from InventSum where InventSum.itemId == WMSOrderTrans.itemId

RE: Spam:Re: [Axapta-Knowledge-Village] Clusteredindex on inventsum inventdim

hi cluster index slows down inserts (or am I wrong), if you activate serial numbers then you keep on adding records to inventdim table (I assume so, never worked on serial numbers) regards harry TVG Tom Vergote [EMAIL PROTECTED] wrote: Hi Harry, thanks for your response, How does

RE: Spam:Re: [Axapta-Knowledge-Village] Clusteredindex on inventsum inventdim

hi did u activate the sql trace and checked if any errors are shown? regards harryTVG Tom Vergote [EMAIL PROTECTED] wrote: Hi Harry, thanks for your response, How does having serial number active change anything? I still don’t feel to confident setting that index, maybe there is