[OAUGNet]-Re: AR Transaction Overview Performance

[Jim <fierosrcul@yahoo.com>]

Has the DBA ran Gather Stats job recently?
Do indexes exists for the columns you are querying on?
If not, get some, if so, have the dba rebuild them.


--- "Clayback, Michael" <mclayback@medsourcetech.com>
wrote:

> Looking for some advice on how to speed up the AR
> Customer Transaction
> Overview form performance.  When querying by any
> qualifier (sales order, trx
> number, customer) query takes an absurd amount of
> time.  Any advice would be
> appreciated.  Version 11.5.8, AR.K
> 
> Michael Clayback
> MedSource Technologies
> 
> 
>
#############################################################
> This message is sent to you because you are
> subscribed to the mailing list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to
> <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to
> <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to
> <OAUGNet-index@oaug.com>
> Send administrative queries to 
> <OAUGNet-request@oaug.com>
> 
> 



		
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>