I have a program with several quries that join 3 tables the one that isproblematic has is as follows:
adminhierarchy has 4.5 million records admincoverage has 1.5 million records adminproducer has quite a few (i cant remember right now) I am trying to select off 3 years worth of data , currently it is LOOPING thru by taxid and has been running for 2 DAYS and is only half done. Note there is other processing then just this query. But this query takes a very long time. sSql = "SELECT AdminHierarchy.WritingAgentID, AdminHierarchy.WritingAgentSlot, " & _ "AdminHierarchy.ProducerID, TaxID, " & _ "(ModalPremium * BillModeID * (PercentOfCase / 100)) AS TotalPaidPremium, " & _ "AdminCoverage.CoverageID, AdminCoverage.CoverageIDSbc, " & _ "AdminHierarchy.RegionCode, AdminProduct.LobId, " & _ "AdminCoverage.StatusID, AdminCoverage.StatusDate, " & _ "AdminCoverage.InitialPremiumDate, AdminCoverage.PaidToDate, GROUPID " & _ " FROM AdminHierarchy " & _ " INNER JOIN AdminCoverage ON AdminHierarchy.CoverageID=AdminCoverage.CoverageID AND AdminHierarchy.CoverageIDSbc=AdminCoverage.CoverageIDSbc" & _ " LEFT JOIN AdminProducer ON AdminProducer.ProducerID=AdminHierarchy.WritingAgentID" & _ " LEFT JOIN AdminProduct ON AdminCoverage.ProductID=AdminProduct.ProductID" & _ " WHERE AdminCoverage.InitialPremiumDate >= " & sFromDate & _ " AND AdminCoverage.InitialPremiumDate <= " & sThruDate & _ " AND TaxID='" & FixSQLString(rs!taxid) & "'" & _ " ORDER BY AdminHierarchy.WritingAgentSlot,AdminCoverage.CoverageId," & _ " AdminCoverage.CoverageIdSbc,AdminHierarchy.ProducerID" Call SendToDwDb(sSql, rs3) Mary Stickney TAG-TMI Data Warehouse / Imaging 402-474-7612 x 3099 [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
