Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Red face Unanswered: Unique Constraint

    My application reports gets slow suddenly, and when i rebuild unique constraints on particular tables then it again come to their normal speed. I made unique constraints with fillfactor as '0' in order to create uniqueness on particular non-primary key columns.
    In these tables, there are entering about 500 records daily.
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Fillfactor has nothing to do with uniqueness. A fill factor of 0 creates a structure with only leaf pages. I'd expect to see performance drop as they fill up.

    Try using the default fill factor, and make sure your tables are properly indexed for the joins you are creating. Also, check the execution plan to see if the optimizer is using the indexes.


Posting Permissions

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