[opt](scan) Use lazy-init for segment iterators and avoid caching all segments in the rowset reader

[mrhhsg]

Proposed changes

Issue Number: close #xxx

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...