Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> and optymalistaion NLSSORT,like

and optymalistaion NLSSORT,like

From: Marcin Zawadzki <marcinz_at_kompakt.pl>
Date: Thu, 7 Nov 2002 08:57:49 +0100
Message-ID: <aqd6d2$p5a$1@news.tpi.pl> 





Greetings ALL



I have problem with optymalistation of nlssort



I have question:


SELECT * FROM sometable


 WHERE nazwa like 'something%'


 ORDER BY nlssort(nazwa,'nls_sort=POLISH')



and index on NLSSORT(nazwa,'nls_sort=POLISH')



I cannot force Oracle (9i) to use INDEX RANGE SCAN in optymalistation.



Any hints?
Received on Thu Nov 07 2002 - 01:57:49 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US