Query never end

[Franco]

On my low cost Intellistation EPRO, one query succeed in about 50 seconds.
The same query,same DB, same Maint Plan...on my super expensive Netfinity 7000M10(2 node Cluster, fiber channel,Raid 1),my query never end.
With Query Analizer I have timeout error (30 seconds default).
Where can I start looking to find the answer?

[Paul]

what does the query look like ? What does it do ?


------------
Franco at 6/25/01 7:29:09 AM


On my low cost Intellistation EPRO, one query succeed in about 50 seconds.
The same query,same DB, same Maint Plan...on my super expensive Netfinity 7000M10(2 node Cluster, fiber channel,Raid 1),my query never end.
With Query Analizer I have timeout error (30 seconds default).
Where can I start looking to find the answer?

[Franco]

this is the query:

CREATE VIEW dbo.V_generale_last
AS
SELECT V_presenza_last.*, V_fam_eco_last.*, V_origine_last.*,
V_permesso_last.*, V_stato_civile_last.*, nominativo.*,
V_persona.*, V_professione.*, V_CB_Numero_Controllo.*
FROM V_persona RIGHT OUTER JOIN
V_professione RIGHT OUTER JOIN
nominativo INNER JOIN
V_presenza_last ON
nominativo.nominativo_id = V_presenza_last.presenza_n_id ON
V_professione.professione_n_id = nominativo.nominativo_id LEFT
OUTER JOIN
V_CB_Numero_Controllo ON
nominativo.nominativo_id = V_CB_Numero_Controllo.CB_Dati_Contribuente_n_id
ON
V_persona.persona_n_id = nominativo.nominativo_id LEFT OUTER
JOIN
V_stato_civile_last ON
nominativo.nominativo_id = V_stato_civile_last.stato_civile_n_id LEFT
OUTER JOIN
V_permesso_last ON
nominativo.nominativo_id = V_permesso_last.permesso_n_id LEFT
OUTER JOIN
V_origine_last ON
nominativo.nominativo_id = V_origine_last.origine_n_id LEFT OUTER
JOIN
V_fam_eco_last ON
nominativo.nominativo_id = V_fam_eco_last.fam_eco_n_id