Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fine tuning a SPROC
Message
De
21/06/2007 10:18:54
 
 
À
21/06/2007 10:12:54
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01234693
Message ID:
01234694
Vues:
24
Do you have an index on Table1.EffectiveDate, Table2.StartDate and Table2.EndDate? Can you identify the performance hit in the execution plan?

>I am trying to fine tune a SPROC that is taking about 25 seconds to run.
>
>I have one table with a record every day. I have a second table with a record for a time frame, and it has a StartDate and EndDate field.
>
>I want to link the tables together in one query. I have been doing something like this:
>
>
>SELECT
>     Table1.Table1ID
>     , Table1.Field1
>     , Table1.Field2
>     , Table1.EffectiveDate
>     , Table2.Table2ID
>     , Table2.Field1
>FROM
>     Table1
>          LEFT OUTER JOIN Table2 ON (Table1.EffectiveDate > Table2.StartDate AND Table1.EffectiveDate < Table2.EndDate)
>
>
>This is getting me the results I want, but at a performance price. Is there a better way of doing this, like loading Table2 into a temp table before joining? Thanks!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform