sql性能实例(sql performance)

oracle sql性能实例：

?

1.需求是取11至100的记录.

性能差一点的sql

SELECT *? FROM (SELECT row_.*, ROWNUM rownum_
???????? ? ? ? ? ? ? ? ? ? ? ?? FROM (SELECT users.id,users.name? FROM my.users users0_) row_ )

????????? WHERE rownum_ <= 100 AND rownum_ > 10

?

性能优良的sql应该是：

SELECT *? FROM (SELECT row_.*, ROWNUM rownum_? FROM (SELECT users.id,users.name
????????????????? FROM my.users users0_) row_ where rownum <= 100 )
?WHERE rownum_ > 10

?