Re: Timeout with Where statement

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/22/04 

Date: Fri, 21 May 2004 22:24:14 -0400

Hi

Try to check query execution plant to see where your query spends most of
the time 

-- 
Val Mazur
Microsoft MVP
"Frank Petrucci" <fpetrucci007@yahoo.com> wrote in message 
news:2E38353C-BAAA-4D47-B4D5-6B96D1061FF3@microsoft.com...
>I tried creating indexes using the fields in the query:
> SELECT TOP 10 *
> FROM  GRS.IDX_DOC INNER JOIN
>               GRS.IDX_DOC_PROP ON GRS.IDX_DOC.DOC_ID = 
> GRS.IDX_DOC_PROP.DOC_ID INNER JOIN
>               GRS.IDX_PROP ON GRS.IDX_DOC_PROP.PROP_ID = 
> GRS.IDX_PROP.PROP_ID
> WHERE (GRS.IDX_DOC.RECORDED_DATE > '1/2/2003') AND 
> (GRS.IDX_DOC.RECORDED_DATE < '1/16/2004')
>
> but I still get a timeout running under enterprise manager. I did not 
> create clustered indexes. Do you think I need to add more fields to the 
> index to make it run faster?

Relevant Pages

  • Re: correlated subquery in the crosstab
    ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... I have students, courses, exam groups containing exams of courses, ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)
  • Re: correlated subquery in the crosstab
    ... I solved my problem using stored queries to act as subqueries. ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)
  • Re: correlated subquery in the crosstab
    ... The first query ... TRANSFORM FirstAS FirstOfscore ... FROM tblStudent INNER JOIN (((tblEduYear INNER JOIN tblExamGrp ON ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)
  • Re: Return just the first record that fits the parameter
    ... Be warned that coordinate subqueries are slow since they run the query one time for each record in the main query. ... FROM tblProcess INNER JOIN ... This is the only record for Plan 06-22. ... It would be convenient to be able to use "ABC 10" as the criteria for ProcName, and return all Plans that include that Process. ...
    (microsoft.public.access.queries)
  • Re: Matching records for an update query
    ... then the update query would look something like ... UPDATE RegisteredMembers INNER JOIN BusinessChanges ...
    (microsoft.public.access.queries)