Re: efficiency random values / sequential ID values in indexes

2024-04-16 Thread Sanjay Minni
Thanks On Mon, Apr 15, 2024 at 6:19 PM Ron Johnson wrote: > On Mon, Apr 15, 2024 at 6:05 AM Sanjay Minni > wrote: > >> Hi >> >> Is there any appreciable difference in using random values or sequential >> values in indexes >> >> in a multi tenanted application there is a choice that the single

Re: efficiency random values / sequential ID values in indexes

2024-04-15 Thread Ron Johnson
On Mon, Apr 15, 2024 at 6:05 AM Sanjay Minni wrote: > Hi > > Is there any appreciable difference in using random values or sequential > values in indexes > > in a multi tenanted application there is a choice that the single field > ID's value is totally random / UUID or the numbers are created

efficiency random values / sequential ID values in indexes

2024-04-15 Thread Sanjay Minni
Hi Is there any appreciable difference in using random values or sequential values in indexes in a multi tenanted application there is a choice that the single field ID's value is totally random / UUID or the numbers are created with a prefix of the tenant. Since all access will be within a