[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] How I can jump rows on my sql

Your mileage may vary. Based on my experience with Oracle,  for some
sizes of query, you may gain with 


Begin-Select
Col
FROM
   (SELECT Col, rownum AS rn
    FROM tab
    WHERE this = that)
WHERE mod(rn, #nth) = 0
End-Select

For other queries you may kill the performance doing that and would be
better off

let #x = 1
Begin-Select
Col
    if Mod(#x, #nth) = 0
      Do process-stuff
   end-if
   let #x = #x + 1
FROM tab
WHERE this = that
End-Select



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users