Couple of questions:
Why do we need to create the following indexes?
Why can we just use PK_tbh_Articles for these columns?
IX_tbh_Articles_Approved
IX_tbh_Articles_ReleaseDate
IX_tbh_Articles_OnlyForMembers
And how come you create more then one index on same table,
"Only one full-text index is allowed per table" (MSDN - CREATE FULLTEXT INDEX )
Also, when I create PK_tbh_Articles index i get this warning:
Warning: Table or indexed view 'Database.dbo.tbh_Articles' has full-text indexed columns that are of type image, text, or ntext. Full-text change tracking cannot track WRITETEXT or UPDATETEXT operations performed on these columns.
Last edited by yevi; August 9th, 2009 at 04:59 PM..
|