Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006
    Posts
    28

    Unanswered: Index - which 1 to choose ?

    good day, everyone

    if i have a transaction table with fields below :

    transaction_no, product_id, product_desc, product_qty, product_txn, transaction_date

    can some expert here point out to me , which is the best cluster-index and non-clsuter index ?

    and possible kindly please explain why is it so? i'm not good in database so just explain like to beginner

    thank you very much for guidance

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Read this:

    http://www.sql-server-performance.com/mr_indexing.asp

    Then come back if you have more questions.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi nakata

    Welcome to the forum

    What are you going to do with the table? Index choice depends on this. Given its name I guess a lot of inserts. Many updates? Much querying? Any foreign keys? Any other fields you are likely to link with in any queries?

    Are any of the fields likely to always increase in value for each successive record added? (e.g. the transaction_no and transaction_date look like good candidates)
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Damn these slow, clumsy fingers of mine And I forgot the phrase "monotonically increasing"
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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