Documents SQL Server 2000, 2005 and 2008 databases.
Moderators: David Atkinson, david connell, Charles Brown
I have noticed that the fillfactor values of indexes appear in the Indexes table but are not present in the SQL Script text.
IDX_UBI_USER_STATUS_ID 60 PS_UBI_USERS_USER_ID
- Code: Select all
CREATE NONCLUSTERED INDEX [IDX_UBI_USER_STATUS_ID] ON [dbo].[UBI_USER] ([STATUS_ID], [USER_ID])
Is it normal?
- Posts: 2
- Joined: Wed Jan 09, 2008 3:43 pm
It appears that the schema options that SQL Doc uses include an option to ignore fillfactors. We should be able to change this easily in the next version of SQL Doc and get the change out soon.
Thanks for pointing this out.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Doc 1
Who is online
Users browsing this forum: No registered users and 1 guest