sql - Heavy cost (99%) for insert in query execution plan -


I as follows to a question: Select 

  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

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.

Image Details Enter Here

So, my question There are:

  1. Why is the selection coming from the cost, and not by the employee commander_IOLG?
  2. Is this speed of the query possible?


Comments

Post a Comment