WHY TO USE SQL SEQUENCE AND ITS DRAWBACKS ?

Vikas Giri

Total Post:33

Points:165
Posted by  Vikas Giri
 1895  View(s)
Ratings:
Rate this:
  1. Vikas Giri

    Post:33

    Points:165
    Why to use SQL Sequence and its drawbacks ?

    In SQL Sequences are used for creating sequence numbers without any overhead of locking but one drawback is that when any of transaction is rolled back the sequence number is lost.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!