Hello,

I have a query which takes a couple of minutes to run. Is it obvious where
the bottleneck is from this execution plan:

PLAN JOIN (JOIN (JOIN (JOIN (SORT (JOIN (Q543B59ACD0D491DD PHYSICAL_COPY
INDEX (IDX_sKfIZDMkd26ITRo1Da5mzQ==), Q543B59ACD0D491DD COPY_CLASSIFICATION
INDEX (IDX_soqMJd+Yux0RNvCbmE9rrg==), Q543B59ACD0D491DD
PROJECT_CODE_DESCRIPTOR INDEX (IDX_lEwvSCR+VZpQCfw5Duxo0A==),
Q543B59ACD0D491DD PROJECT INDEX (PK_f3m9slJ+02gL6hFClhrZvg==),
Q543B59ACD0D491DD COPY INDEX (PK_ZM6SRonqR8AHSQuCISgvnQ==))), PHYSICAL_COPY
INDEX (IDX_PHYSICAL_COPY_LASTMOD)), JOIN (COPY_CLASSIFICATION INDEX
(IDX_soqMJd+Yux0RNvCbmE9rrg==), COPY INDEX (PK_ZM6SRonqR8AHSQuCISgvnQ==))),
PROJECT_CODE_DESCRIPTOR INDEX (IDX_lEwvSCR+VZpQCfw5Duxo0A==)), PROJECT INDEX
(PK_f3m9slJ+02gL6hFClhrZvg==))

Sorry for the cryptic index names.

Thanks


[Non-text portions of this message have been removed]