Home » RDBMS Server » Performance Tuning » Impact of NLS Sort (Oracle10g, UNIX)
icon5.gif  Impact of NLS Sort [message #304752] Thu, 06 March 2008 08:45 Go to next message
Messages: 34
Registered: December 2007
Location: Boston, US


I am having Oracle 10g Installed on Unix. This database is having millions of rows in it. I want to use the NLS_SORT and want to know how is it going to impact on database performace in oracle 10g.

Any ideas?

Thanks and Regards,
Re: Impact of NLS Sort [message #304753 is a reply to message #304752] Thu, 06 March 2008 08:52 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Comparing to what?
If you need a special sort, you need it.
If your question is will it take longer with it than without it. The answer is: of course. It will always take more time to do something than to not do it.

Previous Topic: Reclaiming free space questions
Next Topic: Database Metrics for Capacity Planning
Goto Forum:

Current Time: Fri Jul 28 08:06:51 CDT 2017

Total time taken to generate the page: 0.18459 seconds