Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Thursday, July 6, 2017

how to optimise a view having 3 to 4 derived tabels.

SQLServerCentral » Latest topics
how to optimise a view having 3 to 4 derived tabels.

hi,   ( i need suggestion on coding practice)

   i have a situation , i have one view , whoes structure is like

select x.*

from x

left join (

select x, y,z,poleid from y --

No comments: