Thread: finding last element of an index

finding last element of an index

From
Jim Mercer
Date:
if i have a table:

CREATE TABLE booga
(
name   varchar(20),
addr   varchar(20)
);
CREATE UNIQUE INDEX booga_idx ON booga (name);

is there a fast way to find the last entry in index booga_idx?


--
[ Jim Mercer                 jim@reptiles.org              +1 416 506-0654 ]
[          Reptilian Research -- Longer Life through Colder Blood          ]
[  Don't be fooled by cheap Finnish imitations; BSD is the One True Code.  ]