Re: Accessing ASH is slow
From: Martin Klier <usn_at_usn-it.de>
Date: Wed, 24 Jul 2013 17:48:09 +0200
Message-ID: <51EFF739.5010901_at_usn-it.de>
Hi Henry,
Date: Wed, 24 Jul 2013 17:48:09 +0200
Message-ID: <51EFF739.5010901_at_usn-it.de>
Hi Henry,
it's easy to reproduce:
http://www.usn-it.de/index.php/2013/07/24/how-nls-settings-can-affect-oracles-join-behavior-v-example/
Thanks to Mark for the clarification!
Regards
Martin
Henry Poras schrieb:
> Martin,
>
> Maybe I'm missing something here, but why would the NLSSORT setting
> impact the join condition? Wouldn't the outcome of the join equality be
> the same regardless of the sort setting?
>
> Henry
>
>
-- Usn's IT Blog for Oracle and Linux http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 24 2013 - 17:48:09 CEST