[Axapta-Knowledge-Village] How this code can take 10 minutes to execute.Inventdim table has 4 million rows

[serhad_erdem]

static InventDim find(InventDimId inventDimId, boolean _forupdate = 
false)
{
    InventDim inventDim;
    ;

    if (inventDimId)
    {
       inventDim.selectForUpdate(_forupdate);
        select firstonly inventDim
            index hint DimIdIdx
            where inventDim.inventDimId  == inventDimId;
    }

    return inventDim;
}





Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/