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 ...