Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    138

    Unanswered: I need to create index on a column containing sequential numbers with at least seven

    I need to create index on a column containing sequential numbers with at least seven significant digits. Which index would be best suited for this task?

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Not enough info:

    What are your inserts versus queries?

    Do you have a PK?

    Is there already a clustered index on the table?

    how will the column be updated, inserted and also deleted by?
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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