Problems when using TOP statement
From: Henke (henke_nord_at_hotmail.com)
Date: 01/13/05
- Next message: Kevin Munro: "Time Calculation Query"
- Previous message: Aaron [SQL Server MVP]: "Re: Can this be done w/out a loop?"
- Next in thread: Andrew J. Kelly: "Re: Problems when using TOP statement"
- Reply: Andrew J. Kelly: "Re: Problems when using TOP statement"
- Reply: Anith Sen: "Re: Problems when using TOP statement"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 Jan 2005 15:44:00 +0100
Hi!
I have a query that takes about 3 seconds to process. When I add TOP 20 to
reduce the number of hits the same query takes 18 seconds. Is this a correct
behaviour?
/Henke
- Next message: Kevin Munro: "Time Calculation Query"
- Previous message: Aaron [SQL Server MVP]: "Re: Can this be done w/out a loop?"
- Next in thread: Andrew J. Kelly: "Re: Problems when using TOP statement"
- Reply: Andrew J. Kelly: "Re: Problems when using TOP statement"
- Reply: Anith Sen: "Re: Problems when using TOP statement"
- Messages sorted by: [ date ] [ thread ]