If I have a clustered index on only one column of the table, the column being the primary key and an identity column ( int datatype, Ascending CIDX), then can I go ahead and have the Fill Factor be 100%. I may add more rows at a later date to the table.
Let me know.? Yes, you can add more rows. It won't fragment the index because they are sequential. You might want to consider having that clustered index on something you'll use.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment