Re: How does the cost based optimiser evaluate in-line functions

If you have Oracle 8.1, there is a hint /*+ ordered_predicate */ which may help you in other cases. The tuning manual describes it, and also lists (nearly) all the convoluted ifs and buts.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Rod Stewart wrote in message <7v8mqj$olu$1_at_platinum.sge.net>...
>Colleagues,
>
>I have a query that looks something like this:
>
>1) select count(*) from blah where
>2) and col_a = 39
>3) and col_b is null
>4) (security_admin.some_function(param1, user)) > 0
>
>table blah has 432 records in it, line 2 reduced the result set to 280
>records, line 3 to 21 records. The combination of lines 2 and 3 reduced
the
>result set to 4.
Received on Sat Oct 30 1999 - 09:11:03 CDT