Re: Problems when using TOP statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 10:51:20 -0500

> Maybe it is. But the problem is that when using TOP 30 it works fine
(three
> seconds) and with TOP 20 it doesn't (18 seconds).

Could you please try adding an ORDER BY clause (e.g. to an indexed column).
Since the query is useless and meaningless without the ORDER BY clause (e.g.
no reason to keep it that way), I see little point in arguing about what
happens here or troubleshooting it... 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)

Relevant Pages

  • Re: equijoin of two queries results in no result rows
    ... from the tblNames table and is specified in the GROUP BY statement. ... The GROUP BY clause in both of these was: ... the reverse. ... Both queries GROUP BY clauses were in the same order. ...
    (microsoft.public.access.queries)
  • Re: passing variables into an ORDER BY clause
    ... (Reverse address to reply.) ... "studen77" wrote in message ... One of these parameters I want to use in an ORDER BY clause within the query ...
    (microsoft.public.sqlserver.programming)
  • Re: SICPs exercise 4.68
    ... but the query system's algorithm isn't quite ... I think the problem comes in the clause ... includes the two lists and a third list whose only purpose is to be the same ... a REVERSE that works in both directions. ...
    (comp.lang.scheme)
  • Re: passing variables into an ORDER BY clause
    ... scalar values. ... (Reverse address to reply.) ... page only illustrate queries with a single ORDER BY clause and in trying ...
    (microsoft.public.sqlserver.programming)
  • Re: How to assign row number for each row in result of SELECT?
    ... (Reverse address to reply.) ... > I have SELECT with GROUP BY clause, also I added a calculated column named ... and it should reset for each rowset ...
    (microsoft.public.sqlserver.programming)