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

Thread: SQL query takes 6 hours to execute

Threaded View

  1. 05-03-2010, 04:31 PM #16
    mahajanakhil198
    mahajanakhil198 is offline Senior Member
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    I noticed a strange thing.

    "select count(*) from ....." version of the posted query executes in 2 seconds. There seems to be some problem with the select list. I tried to spot it out using the binary method but the problem seems to be with multiple columns in select list.

    Description of MAM_ASSETS is attached.

    I am trying to fix it up with this information. Please let me know if you have any comments regarding the same.
    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