Re: Accessing ASH is slow

  • From: Martin Klier <usn@xxxxxxxxx>
  • To: Henry Poras <hrp@xxxxxxxxxx>
  • Date: Wed, 24 Jul 2013 17:48:09 +0200

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: