SELECT     dbo.tblAdmin_Positions.Position, LTRIM(dbo.tbl_SeamanMain.LastName) AS Lastname, LTRIM(dbo.tbl_SeamanMain.FirstName) AS Firstname, 
                      LTRIM(dbo.tbl_SeamanMain.MiddleName) AS Middlename, dbo.tblPayroll_Allottees.AllotteeName, dbo.tblAdmin_Banks.BankName, 
                      REPLACE(dbo.tblPayroll_Allottees.AccountNo, '-', '') AS AccountNo, 'PHP' AS AcctCurrency, 0 AS AllotUSD, 
                      dbo.tblPayroll_Allottees.NetAllotment AS AllotPHP, dbo.tblPayroll_VesselLog.ExRate, dbo.tblPayroll_VesselLog.VesselCode, 
                      dbo.tblAdmin_Vessels.Vessel, dbo.tblPayroll_Allottees.AllotteeID, dbo.tblAdmin_Banks.BankAbbrv, dbo.tblAdmin_Branches.BranchName, 
                      dbo.tblAdmin_Positions.IDPosDep, dbo.tblPayroll_VesselLog.PrincipalCode, dbo.tblPayroll_VesselLog.Payroll_Period, 
                      dbo.tblAdmin_Branches.BankCode, dbo.tblAdmin_Positions.Officer, dbo.tblPayroll_Details.BatchNum, dbo.tblAdmin_Vessels.BatchNo, 
                      dbo.tblPayroll_VesselLog.PayrollID, dbo.tblPayroll_Details.SeamanID, dbo.tblAdmin_Positions.PositionAbbrv
FROM         dbo.tblAdmin_Vessels RIGHT OUTER JOIN
                      dbo.tblAdmin_Banks RIGHT OUTER JOIN
                      dbo.tblAdmin_Branches ON dbo.tblAdmin_Banks.BankCode = dbo.tblAdmin_Branches.BankCode RIGHT OUTER JOIN
                      dbo.tblPayroll_Allottees RIGHT OUTER JOIN
                      dbo.tblPayroll_Details RIGHT OUTER JOIN
                      dbo.tblPayroll_VesselLog ON dbo.tblPayroll_Details.PayrollID = dbo.tblPayroll_VesselLog.PayrollID AND 
                      dbo.tblPayroll_Details.PayrollPeriod = dbo.tblPayroll_VesselLog.Payroll_Period ON 
                      dbo.tblPayroll_Allottees.PayrollID = dbo.tblPayroll_Details.PayrollID AND 
                      dbo.tblPayroll_Allottees.SeamanID = dbo.tblPayroll_Details.SeamanID LEFT OUTER JOIN
                      dbo.tblAdmin_Positions RIGHT OUTER JOIN
                      dbo.tbl_SeamanMain ON dbo.tblAdmin_Positions.PositionCode = dbo.tbl_SeamanMain.PositionCode ON 
                      dbo.tblPayroll_Details.SeamanID = dbo.tbl_SeamanMain.SeamanID ON dbo.tblAdmin_Branches.BranchCode = dbo.tblPayroll_Allottees.BranchCode ON
                       dbo.tblAdmin_Vessels.VesselCode = dbo.tblPayroll_VesselLog.VesselCode
WHERE     (dbo.tblPayroll_Details.Included = 1) AND (dbo.tblPayroll_Allottees.PaymentType = 1) AND (dbo.tbl_SeamanMain.IsSeamanActive = 1) AND 
                      (dbo.tblPayroll_VesselLog.Closed = 1) AND (dbo.tblPayroll_Allottees.NetAllotment > 0) AND (dbo.tblAdmin_Branches.BankCode = 2) AND 
                      (dbo.tblAdmin_Vessels.Active = 1) AND (REPLACE(dbo.tblPayroll_Allottees.AccountNo, '-', '') IS NOT NULL) AND 
                      (dbo.tblPayroll_VesselLog.PrincipalCode = 170) AND (dbo.tblPayroll_VesselLog.Payroll_Period = 1004)

quote:

---

Originally posted by chriztoph

I already Indexed the tables.

---

quote:

---

Originally posted by chriztoph

dbo.tblPayroll_Details.Included = Non-Clustered
dbo.tblPayroll_Allottees.PaymentType = Non-Clustered
dbo.tbl_SeamanMain.IsSeamanActive = Non-Clustered
dbo.tblPayroll_VesselLog.Closed = Non-Clustered
dbo.tblPayroll_Allottees.NetAllotment = Non-Clustered
dbo.tblAdmin_Branches.BankCode = Non-Clustered
dbo.tblAdmin_Vessels.Activedbo.tblPayroll_Allottees.AccountNo = Non-Clustered
dbo.tblPayroll_VesselLog.PrincipalCode = Clustered
dbo.tblPayroll_VesselLog.Payroll_Period = Non-Clustered

Am I correct with the indexing? can you give any suggestions on how to indexed properly..thanks..

@visakh16, what do you mean estimated execution plan?

---

quote:

---

Originally posted by chriztoph

ok, thanks..so i need to indexed all those in joins(Foreign Keys).what's the maximum number of columns in one Index?

---