var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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!
what's the view definition?
Man it's too difficult for me to post the view here.
What if I post it with changed names?