DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2010
    Los Angeles

    View Performance issue.

    Hi DBA,

    I am facing critical issue on View performance.
    1) The query taking 1hour 30 mins to run.
    2) We were using same table assigned to different variable, when i changed to use the table only once. The performance bit increased.

    Please see the attached view file.

    Please give me your sugesstion.

    Attached Files Attached Files
    Last edited by Vijaysabari; 07-16-2010 at 05:01 AM.

Posting Permissions

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

Click Here to Expand Forum to Full Width