Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: MSSQL 2005 - Slow INNER JOINs on VIEWs

    We migrated our J2EE application from Oracle to MSSQL 2005 and we have witnessed a lot of issues with performance among others.

    The most noticeable performance issue is when using INNER JOINs on VIEWs. It takes ages. It must be INNER JOIN though since LEFT OUTER join is not an option for some specific cases.

    For example:

    SELECT *
    FROM TABLE1 t
    INNER JOIN VIEW1 v ON t.ID = v.ID


    Indexed VIEWs are also not an option for us since they are too restrictive on the SQL statements. UNIONs are not allowed for example.

    The INNER JOIN is done on the primary key of the table which is a UUID CHAR(36) and the primary key of the table from which the VIEW results are fetched from; which again is a UUID CHAR(36).

    Any ideas how to overcome this issue?

    Thanks in advance!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    what's the view definition?
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2009
    Posts
    2
    Man it's too difficult for me to post the view here.

    What if I post it with changed names?

Posting Permissions

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