View Single Post
  #55 (permalink)  
Old August 9th, 2009, 04:42 PM
yevi yevi is offline
Authorized User
 
Join Date: Mar 2009
Posts: 75
Thanks: 16
Thanked 1 Time in 1 Post
Default

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..