We are using these on materialized views with an explicit order by to do that for us. Have found these most helpful for those types of scenarios (summary / repo

We are using these on materialized views with an explicit order by to do that for us. Have found these most helpful for those types of scenarios (summary / reporting data where we can control refresh/population) - but obviously that is our use case and it may not be very efficient for others.