Antares686 (12/5/2007)

---

Looking at it things look good as all the index lookups are seeks. However, I would still review and try all of my recommendations

1) Try my altered query...

Sorry I had trouble posting it so I posted it to the web at:

I've uploaded the execution plan to

Thanks

Here is my query. 9 tables.

They were seeks not scans.

select [D1].[SID_0COMPANY] AS [SID_0COMPANY]

FROM mdp.[/BIC/FZFIGL_C02] [F] JOIN mdp.[/BIC/DZFIGL_C02T] [DT] ON [F].[KEY_ZFIGL_C02T] = [DT].[DIMID]

JOIN mdp.[/BI0/SFISCYEAR] [S2] ON [DT].[SID_0FISCYEAR] =...