Re: Questioning Oracle Documentation

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 11 Jul 2004 10:07:57 +0000 (UTC)
Message-ID: <ccr3ht$l16$1@sparta.btinternet.com>

This didn't reproduce on my 9.2.0.1.

    null operation: 174
    simple assignment 337
    double conversion 707

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Michel Cadot" <micadot{at}altern{dot}org> wrote in message
news:40f1055c$0$29382$626a14ce_at_news.free.fr...



> And double explicit conversions are 3.5 times faster than direct

assignement in my tests in 9.2


> with an average of 2940 for direct assignement vs 824 with double explicit

conversion.


>

Received on Sun Jul 11 2004 - 05:07:57 CDT