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
amorphous4u
Messages: 34
Registered: December 2007
Location: Boston, US
Member
Hi,

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,
Amit

Report message to a moderator

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: 68665
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.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 09:00:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.