Posted on: 4/10/2012 4:29:22 PM | Views : 324

Good afternoon from Santo Domingo !
Please help with this :
I a view with 1 table and little tables inner join, outer join. All these tables has a unique clutered Index, but I'd like to improve my view too.   I see it's impossible to create a unique index on this view because outer join and has also has a getdate() in WHERE condition that I can't avoid. My question is : should improve my VIEW if I add Non Clustered Index or It's not nessesary because my tables have already Clustered Indexed ?        
SELECT tonyuser.hoteles.Id, tonyuser.HOTELESNOMBRES.HotelesName, tonyuser.HOTELESNOMBRES.HotelesName + N' ' + tonyuser.HOTELESNOMBRES.Stars + N' - ' + tonyuser.EntrePlanLocal.PlanLoc AS Hotelestar, tonyuser.EntreZonas.ZonaIngl ...

Go to the complete details ...