I as follows to a question: Select employees Ayam_aioelji is a very large table, 50 rows about 32M rows POLICINGLOG. About 0.5 m The case of the rows @start_pre and @end_pre are predefined variables in addition to approximately 30 minutes. It took about 30 minutes to run a query, and returns around 600 results. Ask questions by looking at the execution plan I was trying to find the way to bring. I can not work out why the opposition to choose from employeereminder_iLOG, as was the 99% up to query put however. So, my question There are:
c.irn, PLog.policingname, ce. * #caselist investigation ce employeereminder_ilog from ce.caseid = c.caseid Join affairs Join ce.logdatetimestamp on Policinglog PLog (between pLog.startdatetime and pLog.finishdatetime) Where @start_pre and ce.logdatetimestamp between @end_pre
Comments
Post a Comment