Re: Query question
From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 06/11/04
- Next message: Van T. Dinh: "Re: Query within amount of days"
- Previous message: Bill Phillips: "Extract numbers from a string"
- In reply to: Gregg: "Re: Query question"
- Next in thread: Gregg: "Re: Query question"
- Reply: Gregg: "Re: Query question"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 12 Jun 2004 08:35:17 +1000
In the SQL Server Analyzer, check the step that uses the highest percentage
of processing time. The problem will be around there. It likely to be the
hash Table (tunable???).
OTOH, it is much better to use Pass-Through Query since in PTQ, the
processing is done by the SQL Server and only data from the selected rows is
send through the network to the PC.
-- HTH Van T. Dinh MVP (Access) "Gregg" <anonymous@discussions.microsoft.com> wrote in message news:1b42201c44fcc$bd397ac0$a501280a@phx.gbl... > I did use SQL Server's Query Analyzer, that's Analyzer > with a "z", and got the no tunable tables. On the comment > of John's, I replied to it and said, it make s no > difference if the table is joined or not, the runtime is > the same. Thanks for the help so far. Is there anything > else you can suggest? >
- Next message: Van T. Dinh: "Re: Query within amount of days"
- Previous message: Bill Phillips: "Extract numbers from a string"
- In reply to: Gregg: "Re: Query question"
- Next in thread: Gregg: "Re: Query question"
- Reply: Gregg: "Re: Query question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
