Execution plan not show missing index so are there are remainig point to enhance

• ahmed_elbarbary.2010

  Hall of Fame

  Points: 3118

  More actions

  January 3, 2022 at 2:06 am

  #3969158

  I work on sql server 2012

  my execution plan as below

  my query is very slow

  it not show missing index

  so please how to enhance query please ?

  my execution plan as below

  https://www.brentozar.com/pastetheplan/?id=HJbwOAkhF

• frederico_fonseca

  SSCoach

  Points: 16154

  More actions

  January 3, 2022 at 10:01 am

  #3969247

  kindly supply table and indexed DDL for all tables involved as well as row count for each table - and at same time do tell us why table TPartFeature does not have a clustered index.

  And give us an ACTUAL explain plan, not the estimated one you supplied.

  and this is pretty much the same as your previous thread https://www.sqlservercentral.com/forums/topic/after-add-two-statement-stuff-query-executing-take-long-time-as-5-minute