Re: default select order
Date: Wed, 7 Jan 2009 11:51:32 -0800 (PST)
Message-ID: <50c00ca0-d4f9-4c9a-afc3-40cba0ee7a1f_at_t39g2000prh.googlegroups.com>
On Jan 7, 2:29 pm, ddf <orat..._at_msn.com> wrote:
snip
> As far as I know such an order variance shouldn't occur, and I cannot
> produce the OP's posted result with 10.2.0.3.0. This is not a
> question of behaviour between two releases of Oracle, it's differing
> behaviour for the same table and data in release 10gR2 (which patch
> level is still unknown). Given that, the query plans should be the
> same for the two results, leaving one to wonder if this is a bug in
> 10.2.0.1.0 fixed in subsequent patchsets.
You are guessing without a complete definition from the OP of the tables and indexes and statistics involved.
Nothing wrong with taking a guess ...
Oracle has the ability to retrieve column data from an index at times. Selecting one column with the same where clause as a different column "just ain't the same' without a good understanding of relevant indexes if any among other things. Received on Wed Jan 07 2009 - 13:51:32 CST