Re: Add Sequential Number to Column

From: Norbert <usun_to.norbert_at_exbud.com.pl>
Date: Thu, 11 Oct 2001 15:07:17 +0200
Message-ID: <9q45i8$krj$1@news.tpi.pl>

Uzytkownik "Buck Turgidson" <jc_va_at_hotmail.com> napisal w wiadomosci news:f98999c8.0110081003.43ffd234_at_posting.google.com...
> I need to update a non-uniquely indexed column with a sequential
> number. I think I can do it with the following statement, but I am
> concerned about performance, since there are about 3 million rows. Is
> there a faster way to do it than SQL?
>

create sequence mysequence;

update mytable
set sequence_nbr = mysequence.nextval;

drop sequence mysequence;

hope it helps

greets

Norbert Received on Thu Oct 11 2001 - 08:07:17 CDT