Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Auckland New Zealand
    Provided Answers: 1

    Unanswered: Indexing Questions

    Sorry its been a while since I was taught about indexes,

    Can I place indexes on both FK fields of a Associative table?
    and what is the recommended number of rows to place an index on a table for SQL server (if different from other DBMS)?

    and also whats a clustered index?

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    I put clustered indexes on every table though not necessarily for performance reasons. Regarding nonclustered indexes, the number of rows is less significant than the number of pages those rows occupy - this depends on the "width" of the rows and fillfactor.
    The last question is really fundamental - I suggest you read the entries in BoL re indexes & their associated structures otherwise you will just find yourself asking piecemeal questions and having to peice it all together at a later date. Better to get some understanding and then ask about anything you haven't quite grasped.

  3. #3
    Join Date
    Nov 2002
    I guess I would like to know why you ask that question

    It's kinda like DBA 101

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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