Re: Default Query Result Ordering Details


Thank you both for your replies. Yes, I am aware that for all intents
and purposes, the query results for a query without an ORDER BY clause
are returned in random order. I am just interested in understanding
how things work under the hood a little better and figured this was a
good foray into the world of Oracle internals. Are there any resources
that might explain how the access plan and other factors contribute to
the changing pseudo-random ordering of results? Thanks again.

.

Relevant Pages

  • Re: Selecting Rows in groups
    ... >I have seen a mumber of posts on this subject, but am still unsure as how ... > In my Windows Forms application, I am dynamically building a query based ... > in groups (say 10 for discussion purposes). ... > return subsequent groups of 10 records if they desire. ...
    (microsoft.public.sqlserver.programming)
  • Panasonic TX28 Widescreen Query...
    ... my purposes!). ... My only query is, when I power up the TV from cold, as the image appears on ...
    (sci.electronics.repair)
  • Selecting Rows in groups
    ... I am dynamically building a query based on ... in groups (say 10 for discussion purposes). ... return subsequent groups of 10 records if they desire. ...
    (microsoft.public.sqlserver.programming)
  • Indexing 2 sides of a relationship
    ... I have a table which to all intent and purposes is: ... Rec. ... logging the Recieved info. ... How can i make sure ALL dates are picked up via a query? ...
    (microsoft.public.access.queries)
  • Re: SQL Server View in VB
    ... FYI....for most intents and purposes, views are treated pretty much just ... querying data twice....once for the view itself and again for your query ... the sql of the view with the sql of the query where possible to avoid ...
    (microsoft.public.vb.general.discussion)