RE: Operator and condition precedence
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Wed, 9 Sep 2009 09:15:44 -0500 (CDT)
Message-ID: <204066fdd036652686c09163fdd5a0a6.squirrel_at_society.servebeer.com>
Hi guys,
Date: Wed, 9 Sep 2009 09:15:44 -0500 (CDT)
Message-ID: <204066fdd036652686c09163fdd5a0a6.squirrel_at_society.servebeer.com>
Hi guys,
Thanks for the answer, but where is this documented? The 10.1 docs seem to contradict that statement:
http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10800/dciextopt.htm#sthref434
> I presume that the database is using CPU COST based optimization. The
> predicates are not evaluated in reverse order. The CPU COST model will
> rearrange the predicates into the order it thinks is easiest to
> evaluate.
Thanks!
Rich
p.s. Michael, if you check my post carefully you'll see the space in between the quotes. So it's really "and aa.col_2a > '[space]'".
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 09 2009 - 09:15:44 CDT