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