Home » SQL & PL/SQL » SQL & PL/SQL » ROWNUM in 10G
ROWNUM in 10G [message #234090] Sun, 29 April 2007 22:59 Go to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
Hi,

Is it true that

ROWNUM in query in Oracle 10g works slower and results in poor performance of the query.

Thnx
Atul
Re: ROWNUM in 10G [message #234096 is a reply to message #234090] Mon, 30 April 2007 00:18 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What if we say 'yes'?
Are you going to rewrite your application, based on our verdict?
Re: ROWNUM in 10G [message #234098 is a reply to message #234090] Mon, 30 April 2007 00:24 Go to previous messageGo to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
We are in the process of 10g upgrade and so analysing the code level changes required and need to focus on every aspects of it.
Re: ROWNUM in 10G [message #234099 is a reply to message #234090] Mon, 30 April 2007 00:27 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no relation between (calculating) rownum and your performances.

Regards
Michel
Previous Topic: Help
Next Topic: Duplicate Empid
Goto Forum:
  


Current Time: Sat Dec 10 01:26:56 CST 2016

Total time taken to generate the page: 0.11004 seconds