From my experience with NetSuite Support, the underlying select doesn't consider any 'range' conditions while executing ... it simply gets all the results, then slices them before you get them. In short. If you ask for 0,9 ... NetSuite will fetch ALL , then give you 0,9. Its not a performance gain