Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What is sequence?
- Thread starter 5315
- Start date
jimbopalmer
Programmer
A sequence is a memory resident counter for records, if you had to find the maximum disk record and increment it by One and write your record out to disk, there would be massive Disk I/O, by keeping a sequence in RAM, you speed up making new records quite a lot, and your users rarely have to wait on each other.
Just once per key, you create sequence, then you use the sequence in insert (primary_key_value) values (my_key.netval); (real tables will have more columns) I love everyone til they prove otherwise, sadly some prove otherwise SO quickly
Just once per key, you create sequence, then you use the sequence in insert (primary_key_value) values (my_key.netval); (real tables will have more columns) I love everyone til they prove otherwise, sadly some prove otherwise SO quickly
- Status
Similar threads
- Locked
- Question
- Locked
- Question