Re: PL/SQL statement for QUICKLY getting the "next available value"

Jonas Malmsten <jonas_at_malmsten.net> wrote:

> I haven't tried this particular construction myself but it seems
> logical to me that this would be pretty quick.
 

> create index idx_pvi_uuid on pvi_uuid(used_flag, pvi);

You might want to look into binary indexes. They're made for this stuff. A standard index will not work very well, as scanning through an index is "expensive" in time and system resources.

-- 
 P. Larsen