Re: SELECT of records in range

2020-08-01 Thread Peter Falson
In an RDBMS yes, on jBASE (MV platforms) you have to create an index. Sent from my iPhone > On Aug 1, 2020, at 8:51 AM, VK wrote: > >  > Sorry forgot to mention that there's no field with account number, it's just > a part of @ID. Isn't @ID a primary index itself? > > >> On Friday, 31

Re: SELECT of records in range

2020-08-01 Thread VK
Sorry forgot to mention that there's no field with account number, it's just a part of @ID. Isn't @ID a primary index itself? On Friday, 31 July 2020 17:15:36 UTC+2, VK wrote: > > Hi coleagues. > > What is the fastest way to SELECT a set of records from a J4 table: > > @IDs are in the format: