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

Thread: View Performance issue.

  1. #1
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20

    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.

    Thanks
    VJ
    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