Re: SQL Tuning Question

Hi Lisa,

On 28/02/12 00:03, Lisa Hu wrote:
> Thank you for all tips. I added a hint in to rid of FTS. However, the
> cost went to 3 times higher.

I suspect the FTS is part of your main WHERE clause:

 > WHERE mbr_medicaid_id in
 > (
 > SELECT mbr_medicaid_id
 > FROM prembr_834_lockupdt_KY
 > );

Getting rid of that FTS might well increase the execution times which 
would account for the cost going up.

I would suggest that the best way to find out what is really happening 
is to add an alter session set events '10046 trace name context forever' 
before the statement and 'alter session set events '10046 trace name 
context off' after it.

The trace file generate will show you exactly where the time is being 
spent. You can test it manually in a Toad session just by running the 
alter, update, alter.

HTH

-- 
Cheers,
Norm. [TeamT]


------------------------------------

Yahoo! Groups Links

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

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> 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/