Nuno Canas wrote: > I'm not arguing on performance, just functionality. Neither am I. I am just trying to get you to realize what is happening on the server.
> Functionality and flexibility is the point Yes. And the way that happens is dynamically building a new index - which is my point. Obviously Oracle queries all 20 million rows while you wait, re-sorts to the current language, and returns the first row. With Cache', you have other options. But you can do what Oracle does also for a similar penalty. > > I can do that with Cache' too (given function Portuguese^%CNLS). > > > > SELECT * FROM distrito ORDER BY $$Portuguese^%CNLS(descricao)
