I do have table like this
(
uniqueid int
,scandate datetime
,courseno varchar(10)
)
this table has two indexes:
primary key clustered index on uniqueid, scandate
non-clustered index on courseno asc, uniqueid asc, courseno asc
this table can have 10 million records. there are no updates to this table. only data is inserted and selected from this table.
when i created these indexes the default fill factor value is 0. should i change the fill factor.
Thanks
sandeep, see BOL http://msdn2.microsoft.com/en-us/library/ms177459.aspx
Quick answer is probably OK, but read the article to determine if something in your environment (disk space limitation, etc) might want you to change it...
No comments:
Post a Comment