Row

Tuning de Banco, Tuning de SQL, Ferramentas de tuning
Post Reply
Alberto
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Wed, 17 Oct 2007 10:11 am
Location: BA

Use rownum degrades a very consultation?
Top
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Contact dr_gori
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Not at all. The queries remain the same with or without the Rownum.
Top
User avatar
heraldoaraujo
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 41
Joined: Sun, 19 Feb 2012 12:10 pm

No, but preferably for table indexes.
Top
User avatar
fbifabio
Moderador
Moderador
Posts: 199
Joined: Tue, 22 Feb 2011 1:51 pm
Location: São Paulo - SP
Contact:
Contact fbifabio
Fábio Prado
www.fabioprado.net

Alberto,

Use Rownum improves the performance of SQL statement and I demonstrate this in some examples in my Tuning SQL training.

[] S

Fábio Prado www.fabioprado.net
Top
Post Reply

Return to “DBA Tuning”

  • Information

  • Who is online

    Users browsing this forum: No registered users and 12 guests