Re: How to test to VARCHAR2's for equality EFFICIENTLY ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 24 Nov 2003 22:05:52 -0000
Message-ID: <bptvbv$1em$1$8300dec7@news.demon.co.uk>

That depends on whether it is a built-in function an external function - and I think it's a built-in.

I'm also curious about the 'context switch' bit - it gets mentioned from time to time, but there really isn't a "context switch" in the normal meaning of the term - it's all happening without interruption in the oracle executable. Can you clarify what it is that is considered to be the context switch in that case ?

"Frank" <fbortel_at_nescape.net> wrote in message news:bptt05$6bl$1_at_news3.tilbu1.nb.home.nl...
> Jonathan Lewis wrote:
>
> > You might go one step further and check if
> > the (undocumented) function
> > sys_op_map_nonnull()
> > works a little faster.
> >

>
> But that would still be a function call.
> Context switch - overhead - performance loss.
> --
> Regards, Frank van Bortel
>
Received on Mon Nov 24 2003 - 16:05:52 CST