Results 1 to 3 of 3

Thread: Sequence

  1. #1
    Join Date
    Nov 2001
    Posts
    5

    Unanswered: Sequence

    I would like to know the pros and cons of creating a sequence per table vs. creating one sequence to service all tables in a database. What is best practice?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Sequence

    Originally posted by estebangs
    I would like to know the pros and cons of creating a sequence per table vs. creating one sequence to service all tables in a database. What is best practice?
    Usual practice is 1 sequence per table, though there's no logical reason not to have 1 sequence for all tables. But there are performance issues that Tom Kyte discusses in details here:
    http://asktom.oracle.com/pls/ask/f?p...:2985886242221

  3. #3
    Join Date
    Nov 2001
    Posts
    5
    Awesome article. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •