Comment

Avatar

Level 6

15-06-2021

@CedricRey 

You're right about specifying it in general (so using a work table).

But in my specific example, not needed: as this is a schema integer PK, the "order by" doesn't need to be used as it will automatically use the default index (ASC order by default)

 

@Jonathon_wodnicki , after several search the "offset" SQL format is not performant as using a condition in the where clause (and an order by if needed) even on PG/Oracle/MsSQL...

 

So using this technic trick to loop on a table is not a good practice