[Rt-devel] SearchBuilder and sorting in Oracle
SO at schilling.dk
Thu Feb 12 15:46:21 EST 2009
I did look for solutions (and discussions on the subject) before trying to solve this.
It is quite obvious, that it is the Oracle query optimizer that is playing tricks.
You can run the standard DistinctQuery-SQL with:
Alter session set optimizer_mode=choose;
* Get one result
Alter session set optimizer_mode=all_rows;
* Get another result
Alter session set optimizer_mode=rule; // I know - this is not supported :)
* Get a third result.
Fra: rt-devel-bounces at lists.bestpractical.com [rt-devel-bounces at lists.bestpractical.com] På vegne af Stephen Turner [sturner at MIT.EDU]
Sendt: 12. februar 2009 18:58
Til: Jesse Vincent; Steen Olesen
Cc: rt-devel at lists.bestpractical.com
Emne: Re: [Rt-devel] SearchBuilder and sorting in Oracle
On Thu, 12 Feb 2009 12:50:15 -0500, Jesse Vincent
<jesse at bestpractical.com> wrote:
> Steen, I've bounced this into the RT bugs queue for evaluation. Thanks!
There was some discussion about this last year:
Senior Programmer/Analyst - SAIS
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
More information about the Rt-devel