Hi everybody,

Some news......

I have an other index on the table prod_starts:

CREATE NONCLUSTERED INDEX [FK_prod_starts_fitgrp_id] ON [dbo].[prod_starts]

(

[fitgrp_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE...

John Mitchell-245523 (6/25/2013)

---

Lowell (6/25/2013)

---

I think one of the join criterias are using scalar functions though...i think that is the performance killer here:

isn't this three different scalar functions being used to...

Thanks,

Here's the description of the table:

CREATE TABLE [dbo].[prod_starts](

[id] [int] IDENTITY(1,1) NOT NULL,

[linea_id] [int] NOT NULL,

[tipo_art_id] [int] NOT NULL,

[cod_rel_id] [int] NOT NULL,

[fitgrp_id] [int] NOT NULL,

[year] [int] NULL,

[dtsamp] [datetime] NULL,

[dtlotto] [datetime] NULL,

[qmode]...