Re: reordering in paralellism-multiprocessor machine

From: Scott Morris (bogus_at_bogus.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 09:07:24 -0500

As I said - no order by clause, no guarantee. There is a thread in
.progamming with the subject "order by and identity" that was active
yesterday. You might find the discussion interesting as it deals with the
same basic issue. You can search the newsgroups for discussions / rants on
this FAQ.

"Saravana" <Saravana@discussions.microsoft.com> wrote in message
news:0FD75B28-2543-4128-8F6F-E888F5110751@microsoft.com...
> Scott,
> Isn't there any other way of stopping this reordering: tweaking of the
> tables, or the columns..
> In other words: what is the exact quantitative statistic that is
considered
> by the server for executing a query paralelly or serially.. i came to know
> about execution costs, but i am not able to get any useful information
from
> the execution plans from the query anaylzer. What i am more concerned is
that
> query 2 is re-ordered whereas query 1 is ordered...
> Thanks.
>
> "Scott Morris" wrote:
>
> > This has been discussed ad-nauseum. The order of returned rows is never
> > guaranteed unless the query includes an order by clause.
> >
>

Relevant Pages

  • Re: SET NOLOGGING in JDBC url?
    ... It's right it does not have a where clause, the query *should* run ... execution at a time ... isolation level could be the key in this case. ...
    (comp.databases.ingres)
  • Re: Create table and default order by clause
    ... by" clause to use when no "order by" clause is specified in a "select" query ... the only way to guarantee result order is to specify ORDER BY in the SELECT statement that selects from the table. ... Note that it is likely, but not guaranteed, that you will get results ordered in sequence by the table's clustered index in a trivial query with no joins or where clause. ...
    (comp.databases.ms-sqlserver)
  • Help With Slow SQL Query
    ... The table has a clustered index on the primary key. ... The foreign key in the WHERE clause has a non-clustered, ... The execution plan shows a 100% cost on a clustered index scan against the primary key of the table, with a WHERE clause for the ... I had a similar problem with another query which was far more complex. ...
    (microsoft.public.sqlserver.server)
  • ignored words...how to configure
    ... Execution of a full-text operation failed. ... A clause of the query ... Prev by Date: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Inner join
    ... the inner join and then applies the where clause on the results. ... execution with FROM clause, including joins. ... change from query to query. ...
    (microsoft.public.sqlserver.mseq)
Loading