DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 34

Thread: SQL query takes 6 hours to execute

Threaded View

  1. 04-30-2010, 08:14 AM #6
    mahajanakhil198
    mahajanakhil198 is offline Senior Member
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    I executed this query in a a session and traced the session.

    Attached is the formatted output after tkprof.

    Mainly time is taken by CPU.

    How can we reduce the execution of this query? It's teasing me a lot now.
    Attached Files Attached Files
    lucky
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width