[OAUGNet]-Re: [OAUGNetDBA]-Re: Creating GL_BALANCES_N1 index

[Doug Garlin <dgarlin@sbgnet.com>]

John,

Thanks for the input. So far no one has traced the process or looked at 
the execution plan. We just recently (last week) had a bunch of them run 
-- is there any way to look at the execution plans of last week's runs, 
or do we need to rerun them with the trace on?

Thanks,

Doug

Douglas J. Garlin
Financial Systems Director
Sinclair Broadcast Group
Hunt Valley, MD
410-568-2107 (office)
717-368-8603 (cell)
dgarlin@sbgnet.com
www.sbgi.net


On 9/29/2008 12:59 AM, John Kanagaraj wrote:
> Doug,
>
> > We are experiencing serious performance issues with GLBBSU, Upload Budget Amounts. Metalink Note recommends creating the index as follows: create index GL_BALANCES_N1 on gl_balances (code_combination_id, period_name, budget_version_id).
> >
> > Has anyone done this, and if so, how have the results been? Has it delivered the desired improvement, without negative side affects?
>
> Has anyone (your DBA or Developers) traced this process and looked at
> the execution plans? That should show you the issue. Adding a new
> index or changing the column order of standard indexes is always
> risky. To look at the effect of this change, take snapshots of
> V$SQL_PLAN and determine how this index is being used. This needs
> special tuning skills....


#############################################################
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>