[T-SQL] Perfomance issue.. TO otimize Joins

---

Perfomance issue.. TO otimize Joins Posted: 20 Jul 2013 10:48 PM PDT I was joining nearly 5 inner joins and 2 left outer join Final with group byHere i am facing perfomance issue..Please help me!!!!!select ....FROM dbo.FactFDDCellQHourlyCalcsEricsson FDDCALC WITH(NOLOCK)INNER JOIN dbo.FactFDDCellQHourlyPegEricsson1 FDDPEG WITH(NOLOCK)ON FDDCALC.DimDateID = FDDPEG.DimDateIDAND FDDCALC.DimQHourID = FDDPEG.DimQHourIDAND FDDCALC.DimFDDCellID = FDDPEG.DimFDDCellIDINNER JOIN dbo.FactFDDCellQHourlyPegEricsson2 FDDPEG2 WITH(NOLOCK)ON FDDCALC.DimDateID = FDDPEG2.DimDateIDAND FDDCALC.DimQHourID = FDDPEG2.DimQHourIDAND FDDCALC.DimFDDCellID = FDDPEG2.DimFDDCellIDINNER JOIN DimQHour DQON FDDCALC.DimQHourID = DQ.DimQHourKeyLEFT OUTER JOIN #FactFreqCellRelationQHourlyCalcsEricsson CALCON FDDCALC.DimDateID = CALC.DimDateIDAND FDDCALC.DimQHourID = CALC.DimQHourIDAND FDDCALC.OSSC_RC = CALC.OSSC_RCAND FDDCALC.MeContext = CALC.MeContextAND FDDCALC.EUtranCellFDD = CALC.EUtranCellFDDLEFT OUTER JOIN dbo.View_DimFDDCell_Mkt99 D99 WITH (NOLOCK)ON FDDCALC.DimFDDCellID = D99.DimFDDCellIDINNER JOIN #TEMP_RANK SPLON FDDCALC.DimDateID=SPL.DimDateIDAND FDDCALC.DimQHourID = SPL.DimQHourIDAND FDDCALC.DimFDDCellID = SPL.DimFDDCellIDINNER JOIN @Temp_RFASFDDCell_HOURLY Temp ON FDDCALC.OSSC_RC = Temp.OSSC_RCAND FDDCALC.MeContext = Temp.eNodeBWHERE FDDCALC.DimDateID = @DimDateID and DQ.[HOUR]= @DimHourIDGROUP BY FDDCALC.DimFDDCellID

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610